Thank you Sergey. I'll get to work on this at once.

>1. Yes
>2. Yes

>"SELECT * FROM InterfaceDB.dbo.InterfaceTable1".
>

>
>>
>>Given the following scenario:
>>1. One database server running SQL Server 2000
>>2. There are two databases defined: AppDB and InterfaceDB
>>3. Login using Mixed Mode
>>4. Login profile: Appuser (DBO)
>>5. Login added to AppDB and InterfaceDB
>>
>>Question:
>>1. Should I create separate connections to each database: AppDB and InterfaceDB to access their respective tables?
>>2. If I am connected to AppDB, is there a way to access InterfaceDB by referencing the database alias like so: "SELECT * FROM InterfaceDB.InterfaceTable1". Note: I can do this in Oracle.
>>3. If #2 is not possible; is there a way to 'share' the InterfaceDB from AppDB?