| title | sp_dropserver (Transact-SQL) | ||
|---|---|---|---|
| description | Removes a server from the list of known remote and linked servers on the local instance of SQL Server. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azuresqldb-mi-current || >=sql-server-2016 || >=sql-server-linux-2017 |
[!INCLUDE SQL Server - ASDBMI]
Removes a server from the list of known remote and linked servers on the local instance of [!INCLUDE ssNoVersion].
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_dropserver
[ @server = ] N'server'
[ , [ @droplogins = ] 'droplogins' ]
[ ; ]
The server to be removed. @server is sysname, with no default. @server must exist.
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).
An error is returned if you run sp_dropserver on a server with associated remote and linked server login entries, or is configured as a replication publisher. To remove all remote and linked server logins for a server when you remove the server, use the @droplogins argument.
sp_dropserver can't be executed inside a user-defined transaction.
Using sp_dropserver to change the local server name can cause unintended effects or unsupported configurations.
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 [!INCLUDE ssNoVersion].
EXECUTE sp_dropserver 'ACCOUNTS', 'droplogins';