Stored Procedures

Results 1 to 2 of 2

Thread: Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedures

    Hi,<BR><BR>I have two seperate database at two different locations, now I want to write a script/(Stored Procedure) which can help me to update one database with the data of the other database.<BR><BR>How to go about it.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedures

    You have to add the &#039;remote&#039; server as a linked server to the &#039;local&#039; server. Check books online on how to do this.<BR><BR>Then you could use the four part naming:<BR><BR>Select * from Server.database.owner.table <BR><BR>etc. etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts