Audit SQL Logins

  • Comments posted to this topic are about the item Audit SQL Logins

  • Great script, Thanks !

    I had a few databases offline, so I did this to ignore them:

    -- I added the "status" field check for SQL 2000 & 2005

    SELECT name

    FROM sysdatabases

    WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')

    and status <> 66048 -- SQL2005 DB offline

    and status <> 528 -- SQL2000 DB offline

  • Exactly the code I needed! Thanks!

  • Is there any way to find the last login date

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

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