we are using SQL Server SP 4 on W2003 box.

we have a source database otr and a destination newbus

we currently read from the source and insert into destination.

now we want to limit what we query from the source by joining it in a table in
destination.

is this possible. how can i see a table in one database that resides in
another database?

It sounds like what you want to do is use a 3-part naming convention to
reference your source and destination tables. The 3-part naming convention
references tables in the following format: databaseName.ownerName.tableName

e.g.
SELECT *
FROM otr.dbo.otrTable AS t1
JOIN newbus.dbo.newbusTable AS t2
ON t1.Key = t2.Key

Just replace the "otrTable" and "newbusTable" with the table names from the
otr and newbus databases, respecitvely. Good luck!

"Colin" wrote:

In article <6A2B8085-B5BD-4DFD-A784-F9647B7B3336 (AT) microsoft (DOT) com>, =?Utf-8?B?TWF0dA==?= <Matt (AT) discussions (DOT) microsoft.com> wrote:
didn't work until I added otr as a user in newbus