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

How to know which sql login are been used or not by the users.... Expand / Collapse
Author
Message
Posted Wednesday, July 2, 2014 12:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:01 AM
Points: 123, Visits: 462
HI all,

how can i know about unused login in sql server 2005 ???

example-

A login is xxx it was been created 22-01-2013 and i want to know that when was this login last used ??



thanks
Ivan
Post #1588293
Posted Friday, July 4, 2014 12:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:01 AM
Points: 123, Visits: 462
the mentor of this blogs please help
Post #1589217
Posted Tuesday, July 8, 2014 5:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 5:37 AM
Points: 498, Visits: 1,845
You could set up a server-side trace and monitor usage for a while. I don't think there's a way to get historical data if you haven't already started auditing it.

Post #1590303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse