September 1, 2009 at 8:08 am
Anyone knows how to audit trail sp_configure executes? or even find when the instance config values were changed and who changed them?
Thanks
September 1, 2009 at 8:23 am
Kaushik Kumar (9/1/2009)
Anyone knows how to audit trail sp_configure executes? or even find when the instance config values were changed and who changed them?Thanks
Well for a start, if you change anything, it shows in the sql log.
Date01/09/2009 15:20:35
LogSQL Server (Current - 01/09/2009 15:21:00)
Sourcespid53
Message
Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
Another way on SQL 2005 is to create a server level DDL Trigger for that event.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply