Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 29, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Attach Table

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.

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date