Step 2: Define the Remote Servers

Use the system procedure sp_addserver to add entries to the sysservers system table. On the server originating the call, there must be an entry for each remote server that is to be called. The sp_addserver syntax is:

sp_addserver server_name [,server_class] [,network_name]

where:

Example

The following examples create entries for the local server named DOCS and for the remote server SYBASE of class sql_server.

sp_addserver DOCS, local
sp_addserver CTOSDEMO, sql_server, SYBASE