Forum Discussion
Direct Query with two linked servers?
I know Direct Query does not work when retreiving data from two separate servers, in which case Import must be used, but will it work if the two servers are linked?
Wow, been a little bit since I've worked with linked servers. But, I'm going to go with probably not on this one. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. But, those linked servers are still essentially separate instances or references and you generally have to write some funky SQL to reference them.