Remote server VS linked server

hi,
Could any one tell me what is the diff between remote server and linked
server?
I know linked server is for current sql server to access tables......
what about remote server>
thanks,"remote server" is another instance of sqlserver that the local sqlserver
connects to and queries data on behalf of the user. "linked server" is very
much the same thing, except it allows you to connect to any oledb data
source.
-oj
"mecn" <mecn2002@.yahoo.com> wrote in message
news:OyW3DV4TGHA.5500@.TK2MSFTNGP12.phx.gbl...
> hi,
> Could any one tell me what is the diff between remote server and linked
> server?
> I know linked server is for current sql server to access tables......
> what about remote server>
> thanks,
>|||oj wrote:
> "remote server" is another instance of sqlserver that the local sqlserver
> connects to and queries data on behalf of the user. "linked server" is ver
y
> much the same thing, except it allows you to connect to any oledb data
> source.
>
I'm not quite sure about that definition - A remote server could just
as well be on another server.
AFAIK Remote server is just in there for backward compatibility and you
should use linked server.
Regards
Steen|||indeed, remote server is there for backward (sql6x) compatibility.
"Configuring Remote Servers
A remote server configuration allows a client connected to one server
running Microsoft SQL ServerT to execute a stored procedure on another
server running SQL Server without establishing another connection. The
server to which the client is connected accepts the client request and sends
the request to the remote server on the client's behalf. The remote server
processes the request and returns any results to the original server, which
in turn passes those results to the client.
Remote server configurations have been superseded by linked server
configurations in SQL Server version 7.0. Both stored procedures and
distributed queries are allowed against linked servers; however, only stored
procedures are allowed against remote servers. Support for remote servers is
provided for backward compatibility only. If you are interested in setting
up a server configuration to execute stored procedures on another server,
and do not have existing remote server configurations, use linked servers
instead of remote servers.
Remote Server Details
Remote servers are set up in pairs. To set up a pair of remote servers,
configure both servers to recognize each other as remote servers. Then,
verify that configuration options are set properly for both servers, so that
each server running SQL Server allows remote users to execute procedure
calls. Check the configuration options in the Server Properties dialog box
on both the local and the remote servers.
In most cases, you should not need to set configuration options for remote
servers; the defaults set on both local and remote computers by SQL Server
Setup allow for remote server connections.
For remote server access to work, the remote access configuration option,
which controls logins from remote servers, must be set to 1 (the default
setting) on both the local and remote computers. If the setting for either
server's remote access option has been changed, you must reset the option
(for one or both servers) back to 1 to allow remote access. This can be
accomplished through either SQL Server Enterprise Manager or the
Transact-SQL sp_configure statement.
From the local server, you can disable a remote server configuration to
prevent user access to that server. "
-oj
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:eShq9KkUGHA.6048@.TK2MSFTNGP11.phx.gbl...
> oj wrote:
> I'm not quite sure about that definition - A remote server could just as
> well be on another server.
> AFAIK Remote server is just in there for backward compatibility and you
> should use linked server.
> Regards
> Steen