sp_dropmergesubscription (T-SQL)

Drops a subscription to a merge publication and its associated Merge Agent.

Syntax

sp_dropmergesubscription [[@publication =] 'publication']
    [,[@subscriber =] 'subscriber' [,[@subscriber_db =] 'subscriber_db']
    [,[@subscription_type =] 'subscription_type']
    [,[@ignore_distributor =] ignore_distributor]

Arguments

[@publication =] 'publication'

Is the publication name. publication is sysname, with a default of NULL. The publication must already exist and conform to the rules for identifiers.

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname, with a default of NULL.

[@subscriber_db =] 'subscriber_db'

Is the name of the subscription database. subscription_database is sysname, with a default of NULL.

[@subscription_type =] 'subscription_type'

Is the type of subscription. subscription_type is nvarchar(15), and can be one of these values.

 

Value	Description
push (default)	Push subscription
pull	Pull subscription
both	Both a push and pull subscription

[@ignore_distributor =] ignore_distributor

Indicates whether this stored procedure is executed without connecting to the Distributor. ignore_distributor is bit, with a default of 0. This parameter can be used to drop a subscription without doing cleanup tasks at the Distributor. It is also useful if you had to reinstall the Distributor.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropmergesubscription is used in merge replication.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergesubscription.

See Also