Post reply

sp on remote sever

  • January 17, 2013 at 3:03 pm

    #393962

    Hi all,

    I need to be able to search for a stored procedure (from serverA) on serverB and, if not present create it.

    Is it possible on SS2K8R2?

    Thanks,

  • January 18, 2013 at 6:55 am

    #1578698

    Yes, with Linked Servers. The requirement sounds a bit odd though. Why would you be connecting to another server to create a new stored procedure via T-SQL?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply