Linked tables

Hi,
Does anyone know how i can link tables in an SQL DB to an etxernal database,
just like in MS Access?
Many thanks in advance for any assistance
You don't link tables per se. What you do is to set up the remote server as a "linked Server" Read
more about the concept in Books Online, where you find how to do it with SQL commands as well as
through the GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marek" <Marek@.discussions.microsoft.com> wrote in message
news:81955741-5D1F-4CDB-8ED5-7764B9A89D0C@.microsoft.com...
> Hi,
> Does anyone know how i can link tables in an SQL DB to an etxernal database,
> just like in MS Access?
> --
> Many thanks in advance for any assistance

Linked Table

Hi all,
is it possible to have a linked table in sql 2000 in the tables section of e
nterprise manager - the same painless way its done in access?
Many thanks
IGNope. Different technology. SQL Server uses the concept of linked
servers, not linked tables. See the "distributed queries" topics in
SQL BooksOnline for more info.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Wed, 14 Jan 2004 03:46:08 -0800, "Igloo"
<anonymous@.discussions.microsoft.com> wrote:

quote:

---

>Hi all,
> is it possible to have a linked table in sql 2000 in the tables sect
ion of enterprise manager - the same painless way its done in access?
>Many thanks
>IG

---

sql