Databases Users

  • How can I check when is the last time database was used by user. Thank you

  • There's not standard way of finding out when a user/login was used the last time.

    What you can do is either enable Login auditing for succesful logins and then check the error log or if you're on SP2 you can create Logon Triggers which log the time a user logs on to the server.

    [font="Verdana"]Markus Bohse[/font]

  • I need to know which database was used last, I don't care which user, all I need if the database was used by anyone within 6 month

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply