Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dteshome
Starting Member
3 Posts |
 Posted - 2004-10-06 : 18:08:47
|
| Does anyone have a utility for installing a Stored Proc to multiple databases on several different SQL Servers? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-06 : 18:12:54
|
| I guess you could write a batch file using osql.exe to connect to the various SQL Servers. The osql.exe would call a sql file which contains the CREATE PROC script in it. Have a look at osql.exe in SQL Server Books Online for details. It is a command line utility. Here is an example:osql -SServer1 -E -iC:\Scripts\SomeScript.sqlTara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-07 : 02:27:26
|
for maintenance purposes, i'm now exploring master-slave server relationship for easy maintenance. you may want to explore this venue... |
|
|
|
dteshome
Starting Member
3 Posts |
Posted - 2004-10-07 : 20:20:19
|
| I guess noone has a utility to do this. I will work on a utility that reads the name of the server/DB names from a table or file and run the SP creation script. |
|
|
|
|
|
|
Install Stored Proc to multiple SQL Servers/DBs