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