September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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, ...