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 |
|
montague
Starting Member
3 Posts |
 Posted - 2001-10-24 : 03:10:15
|
| I have 5 servers that I would like to run a daily stored procedure on from the one central server. I would like the stored procedure to run from the central server for each and every database on all 5 servers thus creating one output file for all databases under my reign. I guess that I can do this by creating them as remote servers. How do I set this up and what is the syntax to run a stored procedure on another server?Remember I am using SQLSERVER 6.5 and we have not had the go ahead to upgrade these servers. |
|
|
|
|
|
Set up remote servers using version 6.5