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 |
|
leoc50
Yak Posting Veteran
54 Posts |
 Posted - 2012-03-15 : 08:51:43
|
| I wonder if anybody has a way to push sprocs to linked servers?Basically I have a central server where all my supported servers are linked in. I have some a small database on each server with the same stored procs but if I modify one of these (tested in the central server) and I need to pass it along to the other servers I basically have to login to each one and compile the new proc.Does anyone have a better solution for this?thanks!- lec |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 16:07:19
|
| cant you set up replication between them including the required stored procedures?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
leoc50
Yak Posting Veteran
54 Posts |
Posted - 2012-03-19 : 11:40:27
|
| I guess it could be done (have to refresh on it), but doesn't seem to be what I'm looking for.I'd like to execute a one-time push to my 'selected' linked-servers without dealing with timing of replication and/or setting up repl.Any other suggestions?thanks!- lec |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-19 : 15:57:51
|
| for one time you can even use transfer database object task also------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Pushing stored procs to linked servers