Sql Select from Databases on Multiple MSSql Servers
Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])
if not is there any other way to achieve this