Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit SQL Logins Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 2:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 25, 2014 11:20 AM
Points: 1,570, Visits: 673
Comments posted to this topic are about the item Audit SQL Logins


Post #401538
Posted Friday, September 19, 2008 9:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:24 PM
Points: 2,829, Visits: 8,477
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
Posted Friday, June 5, 2009 9:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 4, 2013 2:37 PM
Points: 1, Visits: 102
Exactly the code I needed! Thanks!
Post #729834
Posted Tuesday, June 16, 2009 4:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse