Post reply

Logins

  • March 6, 2007 at 1:34 am

    #119085

    Morning All

     

    Any help on the following?

    I would like to know is there a script to see when last a user or login accessed a database?

    Thanks,

     

    Anchelin

  • March 6, 2007 at 9:05 am

    #693341

    You can run traces, but I don't think that login and logout events will give you the correct info. You probably have to run traces for TSQL-SQLBatchCompleted event or SP-Completed and set the filter for your database.

    Regards,Yelena Varsha

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

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