What’s New in Managing Linked and Remote Servers
With SQL Server 2008, there are no significant changes to the linked servers’ capabilities, and there are virtually no changes in the remote servers area. Of the few changes for linked servers, the following are the most significant:
• Remote servers are being deprecated, and this means system stored procedures such as sp_addserver
, sp_remoteoption
, sp_helpremotelogin
, and sp_addremotelogin
will go away.
• System variable @@REMSERVER
and server-wide settings such as SET REMOTE_PROC_TRANSACTIONS
will also go away.
• The system stored procedure was introduced, such as sp_setnetname
to associate a remote or linked server name with the network name of the server that is remote (not local).
• More ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.