Accessing Table Across Different Server Boxes

[LeonelSanchezJr]

I am working on one box named Box1 and the name of the database is db1. I am using the majority of my tables from Box1 db1, however, I need to access two tables from Box2 db2.

Can this be done?

 

[tlbroadbent]

If you are running SQL 7 or 2000 on Box1, you can link the server on Box2 allowing access to the datbases on Box2. Check the following topics in SQL BOL.

Accessing External Data
Linked servers
sp_addlinkedserver
Distributed Query
OpenQuery Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin