Accessing tables in remote database server from local server.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Accessing tables in remote database server...

Accessing tables in remote database server from local server.

Rate Topic

Display Mode

Topic Options

Author

Message

Joy Smith San

Posted Friday, September 05, 2008 4:46 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 1,380, Visits: 2,335

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.

Post #564447

Stupeo

Posted Friday, September 05, 2008 6:04 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:07 AM
Points: 890, Visits: 774

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

Post #564488

« Prev Topic | Next Topic »

Permissions