September 23, 2007 at 2:31 am
Comments posted to this topic are about the item Audit SQL Logins
September 19, 2008 at 9:43 am
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
June 5, 2009 at 9:24 am
Exactly the code I needed! Thanks!
June 16, 2009 at 4:31 am
Is there any way to find the last login date
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply