S SirMrMike Member Sep 19, 2000 39 0 0 Jun 20, 2002 #1 Would anybody know if it is possible, using enterprise manager or query analyser, in MS SQL 7.0, to query across multiple databases? If so, any tips? Thanks
Would anybody know if it is possible, using enterprise manager or query analyser, in MS SQL 7.0, to query across multiple databases? If so, any tips? Thanks
B bot2600 Platinum Member May 18, 2001 2,075 0 76 Jun 20, 2002 #2 Sure you can, you just have to fully qualify the table with the database name as well, select * from table.database you may also need the owner name as well. I will clarify alittle better tommorow once I can look up more information. Bot
Sure you can, you just have to fully qualify the table with the database name as well, select * from table.database you may also need the owner name as well. I will clarify alittle better tommorow once I can look up more information. Bot