Is there any query code that will allow joining tables that are in different databases running on the same server If yes, how is the connection to each handled
Querying 2 tables in different databases
Hot Topic
- How to ignore timepart when using LookUp with date.
- Reporting Services Error-URGENT!!!
- SQLBindParameter SQL_C_TYPE_DATE HY003 Error
- array as parameter for IN statement
- Sql Reporting Services problem
- SSIS Script Component
- linked server exec stored procdure results in Transaction context in use by another session.
- Deploying with sql server express
- Error:rsErrorReadingNextDataRow
- Can't Deploy AdventureWorks AS Database using Instances of SQL and AS
SQL Server
- Send Mail Task Error
- Cast data type problem.Please help!
- how to start work in SQL Server 2005 enterprise edition
- Am I in the right direction?
- SSAS 2005 - Server Time Dimension - Cube deployment problem
- How to execute SSIS package from stored procedure
- User context that package executes under ?
- Can't use Package Variable to specify the filename for a Connection
- Cannot drop the table transactional replication error 3724
- SQL2005 [264] An attempt was made to send an email when no email session has been established.
Querying 2 tables in different databases
JRHudnutt
You are right, on the client side you can use the same (only one Connection), the rest is handled on the server side.
HTH, Jens Suessmeyer.
Matt Wyckhouse
Sure, you can use the four (or three) part notation for this:
SELECT <columnlist> FROM Database.owner.Objectname
HTH, Jens Suessmeyer.
L. von Wyss
When connecting to the databases with ADO do you open the databases using the same connection object Seems like you would have to.