none
Script to find last logon to SQL Server

    General discussion

  • Please provide me script to pull  when was the last log on to SQL Server for all the logins in SQL Servr 2000 and SQL Server 2005.

     

    Thanks.

    Monday, October 03, 2011 2:21 PM

All replies

  • I think you need to turn on SQL profiler  to capture such info
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 03, 2011 2:28 PM
    Answerer
  • I think you need to turn on SQL profiler  to capture such info
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 03, 2011 2:28 PM
    Answerer