Use 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. The default value is ASEnterprise. 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 SYBASE and for the remote server CTOSDEMO with server class ASEnterprise.
sp_addserver SYBASE, local
sp_addserver CTOSDEMO, ASEnterprise, CTOSDEMO
You must reboot Adaptive Server after your add a local server.
