Friday, February 24, 2012

Cross-server SELECT query

Hi,

Recently the powers-that-be migrated the largest databases from one server to another, more powerful server while keeping some support data on the original server. My problem: I need to run queries on tables spanning both database servers. Unfortunately, I can't find any documentation on how to do this. Does anyone have any ideas?

Thanks!lookup linked servers and sp_addlinkedserver.

No comments:

Post a Comment