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.

Cross database transactions.

Are Cross database transactions enabled by default? Not cross-server,
just cross database. If not what setting should I be looking at?Hi Frank
There is nothing special you need to do to enable cross database
transactions. Just make sure you have the necessary rights to the objects in
both databases.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Frank Rizzo" <none@.none.com> wrote in message
news:%238lZ7g24HHA.4964@.TK2MSFTNGP06.phx.gbl...
> Are Cross database transactions enabled by default? Not cross-server,
> just cross database. If not what setting should I be looking at?