Accessing tables in remote database server from local server.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  September 5, 2008 at 4:46 am

  #382525

  Dear All,

  I have a procedure which pulls data from one database and insert into another. Sofar both the databases were in same server. Now one of the database will be shifted a remote server. Wot are the changes I will have to make in the procedure..? How will I insert into the tables in remote database..?

  Please help.....

  Thanks in advance...

  Santhosh Nair.

• Stupeo

  Hall of Fame

  Points: 3067

  More actions

  September 5, 2008 at 6:04 am

  #867687

  You will need to add a "Linked Server" on the server the queries are running on.

  This will allow you to execute queries as normal (with the addition of the server in the object qualifier) ie:

  insert into local_table

  select * from remote_server.dbo.remote_database.table

  Check out Books On Line for sp_addlinkedserver

  Matt