A system security officer can use sp_dropserver to drop servers from sysservers:
sp_dropserver server [, droplogins]
where:
server – is the name of the server you want to drop.
droplogins – allows you to drop a remote server and all of that server’s remote login information. If you do not use droplogins, you cannot drop a server that has remote logins associated with it.
The following statement drops the GATEWAY server and all of the remote logins associated with it:
sp_dropserver GATEWAY, droplogins
You do not have to use droplogins to drop the local server; that entry does not have remote login information associated with it.
