Monday, March 26, 2012

linked vs remote

What are the differences between Remote Server and Linked Server
anyone have a good reference page ?Remote server was introduced in the first Windows NT version of SQL Server (version 4.2) and allowed
for execution of a stored procedure on another instance:
EXEC srv.db.owner.proc
Linked server is a more modern concept, and allow for referencing tables on another instance:
SELECT ...
FROM srv.db.owner.tblname
...
Sometimes the term Linked Server is used as a superset of Remote Server (including both above),
sometimes the terms are used in a more specific manner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony B." <Test@.spam.ca> wrote in message news:uHZgjtEzGHA.4408@.TK2MSFTNGP05.phx.gbl...
> What are the differences between Remote Server and Linked Server
> anyone have a good reference page ?
>

No comments:

Post a Comment