Last access time for SQL Login

[Simon]

Is there a way to determine the last logon time for a given SQL Login?

[phil mc]

You could enable the security settings to log sucessfull logins, then search through the SQL Errorlog or if you need this info within SQL,

You could (although not recommended - be careful - sort of warning) put an insert trigger on the sysprocesses table in the master DB. BE VERY CAREFUL.

You can capture new logins and times into a user table, then when they logout and back in again, you can do a lookup to see when they last accessed SQL.

I hope someone has a better way as this could result is a rebuild of the master DB if you get it wrong.


------------
Simon at 6/22/01 2:18:11 AM


Is there a way to determine the last logon time for a given SQL Login?