| title | sp_dropserver (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 0fc83e35-0caa-49a3-a4b6-a1890d4f46ef | ||
| caps.latest.revision | 29 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Removes a server from the list of known remote and linked servers on the local instance of [!INCLUDEssNoVersion].
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]
[ @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.
0 (success) or 1 (failure)
If you run sp_dropserver on a server that has associated remote and linked server login entries, or is configured as a replication publisher, an error message is returned. To remove all remote and linked server logins for a server when you remove the server, use the droplogins argument.
sp_dropserver cannot be executed inside a user-defined transaction.
Requires ALTER ANY LINKED SERVER permission on the server.
The following example removes the remote server ACCOUNTS and all associated remote logins from the local instance of [!INCLUDEssNoVersion].
sp_dropserver 'ACCOUNTS', 'droplogins';
Security Stored Procedures (Transact-SQL)
sp_addserver (Transact-SQL)
sp_dropremotelogin (Transact-SQL)
sp_helpremotelogin (Transact-SQL)
sp_helpserver (Transact-SQL)
System Stored Procedures (Transact-SQL)