Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, If I want to know which user has login onto SQL Server a week ago

Status
Not open for further replies.

oneshadow

IS-IT--Management
Dec 23, 2004
125
0
0
ID
Hi,<br>If I want to know which user has login onto SQL Server a week ago and what was he doing in Northwind database, how would I do that?<br><br>Thanks.
 
I don't know about SQL Server 7, but I know that there is an Audit Trail utility in Oracle.&nbsp;&nbsp;&nbsp;You have to enable it&nbsp;&nbsp;before you can use it.&nbsp;&nbsp;&nbsp;It requires a lot of overhead in the form of disk space, memory, etc.&nbsp;&nbsp;&nbsp;When we used it to find out how records were accidentally being deleted and by who, we turned it on, figured it out and then turned it back off... <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top