sp-dropserver-transact-sql.md

---

title: "sp_dropserver (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "database-engine" ms.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:

• "sp_dropserver_TSQL"
• "sp_dropserver" dev_langs:
• "TSQL" helpviewer_keywords:
• "sp_dropserver" ms.assetid: 0fc83e35-0caa-49a3-a4b6-a1890d4f46ef caps.latest.revision: 29 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "=azuresqldb-mi-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

---

sp_dropserver (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdbmi-xxxx-xxx-md]

Removes a server from the list of known remote and linked servers on the local instance of [!INCLUDEssNoVersion].

[!INCLUDEssMIlimitation]

Transact-SQL Syntax Conventions

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

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.

Permissions

Requires ALTER ANY LINKED SERVER permission on the server.

Examples

The following example removes the remote server ACCOUNTS and all associated remote logins from the local instance of [!INCLUDEssNoVersion].

sp_dropserver 'ACCOUNTS', 'droplogins';  

See Also

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)