The master.dbo.sysservers table has two name columns:
srvname is the unique server name that users must supply when executing remote procedure calls.
srvnetname is the server’s network name, which must match the name in the interfaces file.
To add or drop servers from your network, you can use sp_addserver to update the server’s network name in srvnetname.
For example, to remove the server MAIN from the network, and move your remote applications to TEMP, you can use the following statement to change the network name, while keeping the local alias:
sp_addserver MAIN, null, TEMP
sp_addserver displays a message telling you that it is changing the network name of an existing server entry.
