exec sp_addlinkedserver 'server2'
SELECT Table1.Column1, [server2]. [database1].dbo.table1.column1 FROM Table1, [server2].[database1].dbo.table1.column1 LEFT OUTER JOIN [server2].[database1].dbo.table1 ON(Table1.Column1 = [server2]. [database1].dbo.table1.column1) ORDER BY table1.column1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)