Stored procedures for multiserver jobs

  • 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?

  • This was removed by the editor as SPAM

  • 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.

  • 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