Chapter 1: System Procedures

sp_dropserver

Drops a server from the list of known servers or drops remote logins and external logins in the same operation.

sp_dropserver server [, droplogins]

droplogins: indicates that any remote logins for server should also be dropped.

This command drops the remote server GATEWAY:

sp_dropserver GATEWAY

Drops the entry for the remote server RDBAM_ALPHA and drops all remote logins and external logins for that server:

sp_dropserver RDBAM_ALPHA, droplogins

Executing sp_dropserver drops a server from the list of known servers by deleting the entry from the master.dbo.sysservers table.
Running sp_dropserver on a server that has associated entries in the master.dbo.sysremotelogins table results in an error message stating that you must drop the remote users before you can drop the server. To drop all remote logins for a server when dropping the server, use droplogins.
Running sp_dropserver without droplogins against a server that has associated entries in the sysattributes table results in an error. You must drop the remote logins and external logins before you can drop the server.
The checks against sysattributes for external logins and for default mapping to a server apply when Component Integration Services is configured.

Only a System Security Officer can execute sp_dropserver.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect