Linking servers...

[jazerr]

So, I'm in a bit of a bind..

I have a two tables. Each on its own server. There is a relationship between the two, but...they are on different servers..

I need to know how to link the two servers so I can successfully join the tables and get my data..

ANy help would be great.

 

[cmmrfrds]

You could set up a linkedserver on the tables from one server or use a fully qualified name. example from Northwind.

select A.*, B.* from bigtuna.northwind.dbo.Employees A
inner join greatwhite.northwind.dbo.Employees B
On A.employeeid = B.employeeid

 

[osjohnm]

Hi

have a look at the following thread where I showed somebody else how to query from one server to another and how to set up a linked server thru Enterprise Manager or with sp_addlinkedserver.

Thread183-389495

Hope it helps

John