Joining 2 Different SQL Server databases

[strider]

Hi There,
is it possible to join 2 tables where each table is from a different database.
i have an msde database which i need to join a table inside a sqlserver 2000 database.

 

[kulrom]

correct me if i'm wrong but i guess you are trying to import certain table rather but join. It is easiest if you do that through SQL Server Ent. Manager. Right click iver certain DB -> all tasks -> Import Data ... use DTS import/export wizard.

Cheers

 

[strider]

wish i could but they are two different databases in which im using a unique key in one database to obtain data from the other.

they cannot be merge

 

[TechGnome]

DTS = overkill in this case, even more so if it's for a one-off query.... are they on the same server at least? ... hmmm, I see from your OP that they are not.

First thing is to make sure that the username & password that you are using to connect to the two databases are the same. Make sure that user also has the proper permissions.

To get to a table in a different database on a different server, use the following construct:

Server.database.dbo.table (the dbo is going to be litteraly dbo, unless the table has a specific owner (not dbo) in which case it needs to be that username.

Tg