A System Security Officer can use the sp_dropserver system procedure to drop servers from sysservers. The syntax is:
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 in one step. 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 don’t have to use droplogins if you want to drop the local server; that entry does not have remote login information associated with it.
