February 18, 2009 at 1:40 am
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!
February 18, 2009 at 11:18 pm
Any body Have any suggestions/solution on this issue?:(
February 20, 2009 at 10:38 am
Take a look at the 'default' trace for SQl 2005 - it should give you a pretty good start.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply