sp_dropserver
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'