Post reply

Any way to Track database settings changes

  • October 25, 2016 at 11:11 pm

    #314758

    Hi Experts,

    Is any script available for tracking/capturing database setting changes into a sql table so that over a period of timing we can get to know who when made what change on a database example auto_close, auto shrink, auto update stats etc...

    Thanks,

    Sam

  • October 26, 2016 at 1:39 am

    #1908821

    On http://www.simple-talk.com are some nice articles that will get you started.

    See how to document and configure sql server instance settings[/url] for settings on instance level and see database properties health check[/url] for settings on database level.

    Execute it periodically, store the results and compare them to check for any changes over time.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • October 26, 2016 at 12:11 pm

    #1908971

    Thanks a lot HanShi.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply