Look up Configuring Linked Servers in BOL (Books Online).
Don R. Watters
Data Group Manager
Quote:> I'm new to SQL Server 7. I've been using Access 97-2000 for a long
> time now and I'm used to being able to link external databases so I
> can query between tables. I can't figure out how to do that in SQL
> Server 7. I played around with the Data Transformation Services some
> but that is for pulling in data to create a new table. That is not
> what I want to do. I just want to be able to create a view that pulls
> from different tables external and internal. Can anyone help me with
> this? I would really appreciate any help.
Does anyone know how to link one table [Primary Table within the Primary
database] to another set of associated tables in related databases 2, 3,
I can accomplish this very easily in Access97, but have been unable to
determine how to achieve the same using in SQL Server 7.0 with sp1.
Table 1 contains common information to all lower level databases.
Information is segregated by function and for performance and scaling
I have only been able to import the table into related databases, which
is not really what i want to do. What I want is to have tables in lower
level or related databases actually be able to reference and related to
[in diagrams and relationships] the table in the primary database.
Any assistance would be appreciated;