Step 2: Create Server Entries in System Tables

Use the system procedure sp_addserver to add entries to the sysservers table. sp_addserver creates entries for the local server and an entry for each remote server that is to be called. The sp_addserver syntax is:

sp_addserver server_name [,server_class [,network_name]]



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

sp_addserver DOCS, local
sp_addserver CTOSDEMO, sql_server, CTOSDEMO