Users last logon

[Erenst]

Can any one tell me if SQL stores the last logon dat for a user and where. I would like to pull reports re users last logings to the server and then database.

[iburyak]

I don't think there is a system table that holds this information.
You can get current login users but not the once who logged off.

Try:

sp_who

I think it can be maintained by code and update some table with users login information. In my system I keep someting like this but with programming involved.

Good Luck.