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