Audit SQL Logins

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Simon Facer » Audit SQL Logins

Audit SQL Logins

Rate Topic

Display Mode

Topic Options

Author

Message

Simon Facer

Posted Sunday, September 23, 2007 2:31 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 3:18 PM
Points: 1,566, Visits: 606

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

Post #401538

homebrew01

Posted Friday, September 19, 2008 9:43 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:23 AM
Points: 2,580, Visits: 7,292

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

Post #572672

christina.leo

Posted Friday, June 05, 2009 9:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 04, 2013 2:37 PM
Points: 1, Visits: 102

Exactly the code I needed! Thanks!

Post #729834

sguha-845925

Posted Tuesday, June 16, 2009 4:31 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 9:40 AM
Points: 12, Visits: 29

Is there any way to find the last login date

Post #735540

« Prev Topic | Next Topic »

Permissions