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 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 assistanceYou 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 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 assistanceYou 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 databas
e,
> just like in MS Access?
> --
> Many thanks in advance for any assistance