remote server and local server - distributed queries?

I have a remote server that I'm able to successfully register on a local sql
2000 server through EntMgr, and make successful selects on both remote and
local server databases via odbc.

Here's the question - Can I have a local server with some database/tables, a
remote server with some database2/tables, and make a single select statement
using table relationships from each? Without having to use DTS to make
imports/exports into the local server's database?

It seems that the connection object is specific to a server, but is there a
way to handle the reference to the remote server's database through a
database in the local server so that the connection object thinks
everything's local and can remain one-database-server-specific?

Sorry if I've communicated this poorly. I'd appreciate any responses.

Yes...you can do this.
A query can include tables on a linked server by using 4
part naming conventions:
server.database(or catalog).owner(or schema).table
You can also use some of the other distributed query
functions such as Openquery to do this.

-Sue

On Thu, 10 Feb 2005 08:55:03 -0800, janetb
wrote:

 >I have a remote server that I'm able to successfully register on a local sql
 >2000 server through EntMgr, and make successful selects on both remote and
 >local server databases via odbc.
 >
 >Here's the question - Can I have a local server with some database/tables, a
 >remote server with some database2/tables, and make a single select statement
 >using table relationships from each? Without having to use DTS to make
 >imports/exports into the local server's database?
 >
 >It seems that the connection object is specific to a server, but is there a
 >way to handle the reference to the remote server's database through a
 >database in the local server so that the connection object thinks
 >everything's local and can remain one-database-server-specific?
 >
 >Sorry if I've communicated this poorly. I'd appreciate any responses.