Last login date for sysadmins

• DG 9336

  SSC Enthusiast

  Points: 149

  More actions

  November 3, 2009 at 3:10 am

  #216959

  I've identified a number of logins on our live servers that have sysadmin rights. I suspect most of these are not actually in use but before disabling them wanted to check when they were last logged in.

  Is there any way of doing this ? I can't find anything in the DMVs or sys views.

  This is for SQL Server 2005 and 2008.

  Thanks

  D

• beath

  SSCrazy

  Points: 2939

  More actions

  November 6, 2009 at 9:03 am

  #1075947

  Hi

  This information isn't stored in any tables or views. You're going to have to setup auditing or a profiler trace for a couple of weeks and see who logs in. Certainly that's the case for 2005, I've not looked into this for 2008 but I'm guessing it's the same.

  cheers