November 3, 2011 at 10:32 am
Hi @all,
(and sorry for my pore english)
We want to track al changes within the SQL-Server configuration,
IMHO shown within the view master.sys.configurations.
As i know there is no way to create a trigger for this place,
so i've to copy the configuration values and compare with the last saved state.
In this way i can't easy see the user how changed the value.
Is there any other way to do this?
Thanks in advance!
Sven
November 3, 2011 at 2:54 pm
Not that i know of. Perhaps a server level DDL trigger, but just taking regular snapshots of sys.configurations is the simplest way.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 4, 2011 at 4:40 am
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply