MS SQL 2008 script to change a configuration setting in multiple databases.

I have 35 databases that I have to change a setting in the config table once a month for testing our DR setup. Each database has a setting and each one has to changed to a different setting.

I think a script would do this but I have no idea how to start.
LVL 1
jimmylew52Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jimmylew52Connect With a Mentor Author Commented:
Definitely a cool tool but I do not see that it will help me.
0
 
spikellyCommented:
SQL 2008 brings a lot of improvements and one of them is the POLICY-BASED MANAGEMENT. This allows you to administrate and easy manage your server and database settings !
Check here:
1 - http://www.mssqltips.com/tip.asp?tip=1492
2 - http://www.databasejournal.com/features/mssql/article.php/3739386/Policy-based-Management-in-SQL-Server-2008--Part-I.htm
3 - http://dotnetslackers.com/articles/sql/Policy-Based-Management-Create-Evaluate-and-Fix-Policies.aspx

Regards

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.