Solved

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

Posted on 2010-08-30
2
500 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:jimmylew52
2 Comments
 
LVL 5

Expert Comment

by:spikelly
ID: 33566879
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
 
LVL 1

Accepted Solution

by:
jimmylew52 earned 0 total points
ID: 33570025
Definitely a cool tool but I do not see that it will help me.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trying to get a Linked Server to Oracle DB working 21 76
Job - date manual 1 41
average of calculation (TSQL) 4 33
SQL server client app 3 26
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question