Post reply

Last login date for sysadmins

  • 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

  • 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

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

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