Post reply

SQL syntax help

  • September 28, 2005 at 10:05 am

    #102827

    Could someone tell me how to run a procedure on a Remote Database please.

     

    Thanks in advance

     

     

  • September 28, 2005 at 10:10 am

    #593740

    exec dbname.dbo.spname

  • September 28, 2005 at 10:30 am

    #593748

    sorry, I forgot to say, the Remote database is on a seperate server.

  • September 28, 2005 at 11:38 am

    #593768

    check out sp_addlinkedserver in BOLS.

  • September 29, 2005 at 9:13 am

    #594069

    you would do this:

    Execute servername.databasename.ownername.procedurename

     

    then pass parameters like you normally would

  • September 29, 2005 at 11:45 am

    #594132

    Prior to that you need to setup a linked server to use a 4 part objectname. I believe that OPENQUERY does not have that prerequisite. Check out BOL for:

    Linked Server

    OPENQUERY

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 6 posts - 1 through 5 (of 5 total)

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