Connecting Two tables fromDiffernt servers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Connecting Two tables fromDiffernt servers

Author

Topic

jayanth_jyothi
Starting Member

11 Posts

Posted - 2004-03-15 : 00:40:24

I have two servers namesly Sql-Server1,Sql-Server2 in the same network..
I have to Join Table A from Sql-Server1 with Table B from Sql=server2 with the join query...

thanks in advance..
jayanth

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-03-15 : 01:24:46

You can setup Server2 as a Linked Server on Server1. See the section on "Linked Servers" in the Books Online. You can also do it in Query Analyzer:


USE master
GO
EXEC sp_addlinkedserver 'Server2', 'SQL Server'
GO

And then you can query the tables using a four part name like this:

SELECT colA, colB FROM LinkedServerName.Database.Owner.TableName

OS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources