exec sp_addlinkedserver @server = 'test'
select * from [server].[database].[schema].[table]
select * from [test].[testdb].[dbo].[table]
Exec sp_addlinkedserver [ServerName]
select * from [ServerName].dbo.[TableName]
SELECT t1.Col1 , t2.ColA FROM server1Table t1 INNER JOIN OPENROWSET('SQLNCLI', 'Server=Server2;Trusted_Connection=yes;', 'SELECT t2.ColA, t2.TheId FROM dbname.dbo.tableName') AS t2 ON t1.TheId = t2.TheId
Sp_AddLinkedServer 'DestServerName' Sp_AddLinkedSrvLogin Sp_TestLinkedServer
Select * from DestServerName.DatabaseName.Schema.ObjectName Go
Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions
Login to post response