Post reply

Sptore Procedure to Access and Update Tables Across Multiple MSSQL Servers

  • September 7, 2005 at 7:51 am

    #110277

    I have a requirement to create a stored procedure which needs to interact with a table(s) stored on different MSSQL servers on different machines in the same network.

    How can i setup such an environment giving that I will be running the Store procedure from one of the servers on the machine to interact with tables on the other servers and current server.

    I need the ability to "Attach" another database server ... (Access Terminology )

    Best regards,

    David Swindon

  • September 7, 2005 at 8:10 am

    #588097

    I just found some information regrarding "linked servers" in the MSSQL Help. Is this the correct place where i should be looking?

    Thanks and regards,

    David Swindon

  • September 7, 2005 at 8:13 am

    #588099

    Yup.  Linked Servers is probably what you want.  Then you can reference tables on other servers quite easily in your query.

    You can also use OPENROWSET, but it's much more cumbersome to code.

  • September 7, 2005 at 9:17 am

    #588124

    Got it to work thanks for the feedback.

     

    Best regards,

    David Swindon

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

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