Hi all,

Is there a

Connect to <Database1>, <Database2> user <Admin> using <Password>; ??

TIA,

Newbie

You can not connect to two databases in a single command. In one command window, the connection is only to one database at a time.

Not quiet ...

You may set CONNECT TYPE 2 and connect to more than one database in the same UOW ...

The reason i wanted to do that was, I need to access tables across two databases whose schemas are different and the user accesses are different. Only a Admin can access both.

Database1 has a table TBLDB1 with DB1Col1, Db1Col2, Db1Col3
Database2 has a table TBLDB2 with DB2Col1, Db2Col2, Db2Col3

Where DB1Col1 = DB2Col1 (P.Key)

I need to access DB2Col2 and DB2Col3. Something like

Select DB2Col3, DB2Col2 from TBLDB2 where DB1Col1 = DB2Col1

Thanks,
Newbie

Federated Databases is something you'll need

Cheers
Sathyaram