Question:
I have 2 databases in SQL7. I need to attach one table, TB1, from DB1 to DB2, to run a join query.
My query uses TB1 from DB1 and TB2 from DB2.I open the DB2 with ADO .How can I attach this table?This works in Access.
Answer:
I think what you need to do is link the servers so that you can run distributed queries.
From BOL:
Create a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as SQL Server, remote stored procedures can be executed.