Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
In this article I will describe the Detach & Attach 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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now