Microsoft® SQL Server 2008 R2 Unleashed

Remote Server Setup

You can assume that the local server is called SQL08DE01 and the remote server is called SQL08DE02 (as shown in Figure 54.1). First, you need to use sp_addserver to add the remote server name to the system table in the master database if it’s not defined already. But first, let’s see what servers are already defined at the local server. To do so, you run sp_helpserver from the local server (SQL08DE01). This provides you with the complete list of local and remote servers known to this server:

You can also see the same information by doing a simple SELECT against the sys.servers system view:

SELECT * FROM sys.servers

Generally, ...