Post reply

How do you determine a user's "last login" in SQL Server 2000?

  • October 31, 2007 at 7:32 am

    #183309

    is there a way to determine a user's last login in SQL Server 2k? if so, how?

  • October 31, 2007 at 7:46 am

    #747069

    Sorry no there is not in 2000.

  • October 31, 2007 at 8:51 am

    #747118

    Antares is right in that you can't determine this after the fact.

    You can set up a trace for logins and just track this over time. If you only get logins, then you'll get minimal data in the trace and the overhead is low.

    For the server properties, security tab, you can audit all logins (I wouldn't do success only) and search the error logs as well.

  • October 31, 2007 at 9:00 am

    #747128

    In SQL 2000:

    In the Serverproperties enable Login auditing for succesfull logins (or all). Then all logins will be to logged and you can query the SQL Errorlogs.

    Under SQL2005 with SP2 you can create Logon Triggers.

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

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

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