September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Remember that remote servers are supported in SQL Server 2008 for backward compatibility only. (Remote servers are being deprecated!) By definition, a remote server is a server you access as part of a client process without opening a separate, distinct, and additional direct client connection. SQL Server can manage the communication between servers using Remote Procedure Calls (RPCs). Essentially, the “local” SQL Server to which the client is connected opens another connection to the “remote” server and submits a remote stored procedure request to the remote server. Execution results are passed back to the local server, and they are then passed back to the originating client application (see Figure 54.1).
Figure 54.1 ...