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 track MSSQL Login id changes Expand / Collapse
Author
Message
Posted Wednesday, February 18, 2009 1:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 12:52 AM
Points: 8, Visits: 299
Hi,

I want to track the changes in mssql login ids. What I mean is whenever the new login creates or existing get deleted or any new rights(Rolls and database rights)assign to particular login, I want to track them.
I want the complete information like what changes are done and who have made these changes.

I have already tried in MSSQL 2005 with the help of DDL trigger (LOGON), but it is not giving me information.If any db rights/Rolls assigned or removed for particular user its not loging in event fired by the trigger as it is DDL trigger.
Also I don’t want to use/run sql trace continuously for it as it will affect the server performance.

Please Help!

Post #659153
Posted Wednesday, February 18, 2009 11:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 12:52 AM
Points: 8, Visits: 299
Any body Have any suggestions/solution on this issue?
Post #660067
Posted Friday, February 20, 2009 10:38 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, November 22, 2013 11:05 AM
Points: 3,108, Visits: 2,116
Take a look at the 'default' trace for SQl 2005 - it should give you a pretty good start.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #661509
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse