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?
--sb--