• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

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.
1 Solution
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


jimmylew52Author Commented:
Definitely a cool tool but I do not see that it will help me.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now