Hi There
I am in the process of cosolidating sql servers.
One of them literally has hundreds of sql logins, obviously i need to clean these up, however i a not sure how to determine when a user last logged in ?
How can i find out the last login date of a user ?
Thanx
Hi,
AFAIK this is not stored in tables in SQL Server, but it is either stored in
1. The event log if you turned on the Audit feature in the server properties.
2. In the c2 audit logs (if turned on)
3. In the profiler trace (if you are running one and are wathing the Audit events on the server)
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Oh man that is bad news i guess, i could spend days sifting through the event logs, and even then i wont be sure a login is not used, for example if someone simply has not logged in this week.
Thanx Anyway
