Post reply

Users Last Login Date

  • January 27, 2005 at 6:16 am

    #87379

    How can i know the last login date for a particular user ??

    Thanks in advance.

     

  • January 27, 2005 at 9:51 am

    #539381

    If you have auditing enabled, you can check the SQL Server error log.

  • January 27, 2005 at 10:04 am

    #539387

    If the user is still connected to server you can find out it from login_time column from sysprocesses table.

  • January 27, 2005 at 10:05 am

    #539390

    Otherwise you can trace event class "Security Audit -> Audit Login" (best way to do it not with Profiler, but with stored procedures, like sp_trace_create, sp_trace_setevent etc.).

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

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