To use a table in one database while also retrieving data from another
database, it is necessary to use 'Four Part Names', in the style of
Server.Database.Schema.Table.
You may wish to review the use of 'Linked Servers' in Books Online.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
[quoted text, click to view] "Rob M" <RobM@discussions.microsoft.com> wrote in message
news:2CE63B96-03B2-41AA-9FE3-0BD6641DF3F3@microsoft.com...
> Well, following your advice, I THINK that I succeeded. I filled out the
> form
> as best I could and a new object with a link icon now shows up under
> Linked
> Servers. But I am not sure that a link really has been established and,
> in
> any case, I don't know how to use SSMS to see the tables in the database.
>
> Thanks again for your help.
>
>
> "Arnie Rowland" wrote:
>
>> If you are using SQL 2005, and SSMS, then in Server Explorer, click on
>> [Server Objects], then right-click on [Linked Servers] and select [New
>> Linked Server] and fill out the form with the appropriate information.
>>
>> If you are using SQL 2000, and Enterprise Manager, then for your server,
>> click on Security and right-click on [New Linked Server].
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> You can't help someone get up a hill without getting a little closer to
>> the
>> top yourself.
>> - H. Norman Schwarzkopf
>>
>>
>> "Rob M" <RobM@discussions.microsoft.com> wrote in message
>> news:E293867D-E57F-410B-9A49-98B711C986F2@microsoft.com...
>> > From my SQL Server database, I would like to add a link to a table in
>> > 4D.
>> > I
>> > don't see how to do that, and cannot find any documentation. Can
>> > anyone
>> > help?
>>
>>
>>
