June 19, 2003 at 1:00 am
Hi!
If I create a multiserver job, that runs a stored prosedure, then I need to have this stored procedure on all target servers before I run this job, right?
Is it possible to create a stored procedure on a master server and copy it on ALL target servers at once, with multiserver administration?
June 24, 2003 at 8:00 am
This was removed by the editor as SPAM
June 24, 2003 at 11:12 am
Are you talking about Linking to multiple servers and running a stored procedure on each server, then yes you would have to have the procedure on all remote SQL Servers. An easy way to check for the procedure is to check sysobjects in the database that you should have the procedure in.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
June 25, 2003 at 5:14 am
NO! I am talking about multiserver administration...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy