sp_dropserver (T-SQL)

Removes a server from the list of known remote and linked servers on the local Microsoft® SQL Server™.

Syntax

sp_dropserver [@server =] 'server' [, [@droplogins =]{'droplogins' | NULL}]

Arguments

[@server =] 'server'

Is the server to be removed. server is sysname, with no default. server must exist.

[@droplogins =] 'droplogins' | NULL

Indicates that related remote and linked server logins for server must also be removed if droplogins is specified. @droplogins is char(10), with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

Running sp_dropserver on a server that has associated remote and linked server login entries results in an error message stating that logins must be removed before removing the remote or linked server. To remove all remote and linked server logins for a server when removing the server, use the droplogins argument.

sp_dropserver cannot be executed inside a user-defined transaction.

Permissions

Only members of the sysadmin or setupadmin fixed server roles can execute sp_dropserver.

Examples

This example removes the remote server ACCOUNTS and all associated remote logins from the local SQL Server.

sp_dropserver 'ACCOUNTS', 'droplogins'

See Also