Is it possible to get data from 2 servers in the same sql statement? For example
select [server1].[dbo].[table1].*,[server2].[dbo].[table1].*
from ......etc.
Esentially, I want to draw data from 2 tables on 2 different servers in the same statement. Does anyone know if this is possible or the correct syntax for this?
Question
jonbob
Is it possible to get data from 2 servers in the same sql statement? For example
Esentially, I want to draw data from 2 tables on 2 different servers in the same statement. Does anyone know if this is possible or the correct syntax for this?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts