LINKED SERVER

What is the usage of linked server? Thanks.
You use linked servers to query remote database, that linked server can be
any ODBC / OLE DB Databsource tat can be setup as a linked server, the
spectrum reaches from SQL Server to mainframe system as well as simple text
files which can be accessed via a linked server. The purpose is, to use it as
if it would be a "normal" local datasource in qour queries, e.g. Select *
from [linkedserver].[database].[owner].[objectname].
If some of the parameters in the four part name don′t make any sense (like
the owner and the database name in Access, you can just leave them out like:
Select * from [SomeAccessLinkedServer]...[Nortwind])
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"00Eric Clapton" wrote:

> What is the usage of linked server? Thanks.
>
>
|||How can I set it up?
"Jens Susmeyer" <Jens@.[Remove_that][for contacting me]sqlserver2005.de>
wrote in message news:02C3392B-2590-4DCD-B1B8-771A705342B2@.microsoft.com...[vbcol=seagreen]
> You use linked servers to query remote database, that linked server can be
> any ODBC / OLE DB Databsource tat can be setup as a linked server, the
> spectrum reaches from SQL Server to mainframe system as well as simple
> text
> files which can be accessed via a linked server. The purpose is, to use it
> as
> if it would be a "normal" local datasource in qour queries, e.g. Select *
> from [linkedserver].[database].[owner].[objectname].
> If some of the parameters in the four part name don′t make any sense
> (like
> the owner and the database name in Access, you can just leave them out
> like:
> Select * from [SomeAccessLinkedServer]...[Nortwind])
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "00Eric Clapton" wrote:
|||You can refer to the "Configuring Linked Servers" topic in SQL Server 2000
Books Online or this link:
http://msdn.microsoft.com/library/en...erver_4uuq.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.