Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to search and fetch data from 3 different databases with single connection

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-29 : 21:52:41
Ananth writes "HI,
We have data in different table in different 3 databases. Since we need searching the data for testing, development. My question is how can I just have search result from all the 3 database actually it has to fetch differenct data from different database. I do not want the application have three connection to three different database. I would like the application look at it as one database. This situation is only for the development and testing stage. Taking into account of all the backup, it takes up space very fast. Any idea?

Thanks
Ananth K"
   

- Advertisement -