How to data of a table from one server in another in SQL Server?

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