Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_dropsubscriber (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_dropsubscriber (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Removes the Subscriber designation from a registered server. This stored procedure is executed at the Publisher on the publication database.

Important note Important

This stored procedure has been deprecated. You are no longer required to explicitly register a Subscriber at the Publisher.

Topic link icon Transact-SQL Syntax Conventions

sp_dropsubscriber [ @subscriber= ] 'subscriber' 
    [ , [ @reserved= ] 'reserved' ] 
    [ , [ @ignore_distributor = ] ignore_distributor ]

[ @subscriber= ] 'subscriber'

Is the name of the Subscriber to be dropped. subscriber is sysname, with no default.

[ @reserved= ] 'reserved'

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[ @ignore_distributor = ] ignore_distributor

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.

Community Additions

ADD
Show:
© 2015 Microsoft