Query across multiple databases/SQL Servers

[RichardF]

Is it possible to run a single query that pulls data from multiple
tables in multiple databases, perhaps also from multiple SQL Servers?

Any input would be appreciated.

Thanks!

RichardF

[Quentin Ran]

Yes. Specify the server and database:

select Select_Column_List
from Server_Name.DB_Name.Object_owner.Table_or_view_nam e

If from another server, you need to set up a linked server. See Linked
Server in Books Online.
"RichardF" <no****@no.where.com> wrote in message
news:41**************@msnews.microsoft.com...

Is it possible to run a single query that pulls data from multiple
tables in multiple databases, perhaps also from multiple SQL Servers?

Any input would be appreciated.

Thanks!

RichardF