select * from [OtherServerName].[OtherDB].[dbo].[OtherTable] SELECT * FROM [SERVER2NAME].[THEDB].[THEOWNER].[THETABLE]
SELECT a.*, b.* FROM [Server2].[Database2].[YourSchema2].[Table2] AS a JOIN [Database1].[YourSchema1].[Table1] AS b ON a.SomeColumn2 = b.SomeColumn1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)