Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
Removes the Subscriber designation from a registered server. This stored procedure is executed at the Publisher on the publication database.
Important
This stored procedure has been deprecated. You're no longer required to explicitly register a Subscriber at the Publisher.
Transact-SQL syntax conventions
sp_dropsubscriber
[ @subscriber = ] N'subscriber'
[ , [ @reserved = ] N'reserved' ]
[ , [ @ignore_distributor = ] ignore_distributor ]
[ , [ @publisher = ] N'publisher' ]
[ ; ]
The name of the Subscriber to be dropped. @subscriber is sysname, with no default.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
0
(success) or 1
(failure).
sp_dropsubscriber
is used in all types of replication.
This stored procedure removes the server sub
option, and removes the remote login mapping of system administrator to repl_subscriber.
Only members of the sysadmin fixed server role can execute sp_dropsubscriber
.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today