Solved

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

Posted on 2010-08-30
2
498 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

831 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