Audit trailing sp_configure

• G33kKahuna

  SSCommitted

  Points: 1726

  More actions

  September 1, 2009 at 8:08 am

  #210387

  Anyone knows how to audit trail sp_configure executes? or even find when the instance config values were changed and who changed them?

  Thanks

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 1, 2009 at 8:23 am

  #1047558

  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]