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:
server_name is the name used to identify the server. It must be unique.
server_class is one of the supported server classes, defined in Chapter 4, “Server Classes.” The default value is sql_server. If the value is local, network_name is ignored.
network_name is the server name in the interfaces file. This name may be the same as the server_name specification, or it may be different. If network_name is not provided, the default value is the server_name.
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
