Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

Attach Table

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

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