Post reply

Last login date

  • July 5, 2006 at 9:18 am

    #61285

    Hi all,

    Using SQL 2000.  Is it possible to see the last time an SQL Login accessed SQL?

    I have done profiler traces and am 99% sure that the logins are no longer required.  I would just like to confirm the last login date before I get rid of these logins!

    Thanks for any help/advice.

  • July 5, 2006 at 11:24 am

    #647572

    Another method is to turn the Audit level to All on the security tab of server properties.  After a restart of SQL server all login events will be written to the event log.  

    I used both methods before my last round of login cleanup to make sure i didn't miss anything.

  • July 5, 2006 at 12:09 pm

    #647591

    I use a trace with login events. I find it more convenient because we can run queries to get data from the trace.

    Regards,Yelena Varsha

  • July 6, 2006 at 2:41 am

    #647688

    Thanks for your responses.  I'll give them a try.

     

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

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