Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_dropmergesubscription

SQL Server 2000

Drops a subscription to a merge publication and its associated Merge Agent. This stored procedure is executed at the Publisher on the publication database .

Syntax

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

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 Push subscription.
pull Pull subscription.
both (default) 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.

[@reserved = ] reserved

Is reserved for future use. reserved is bit, with a default of 0.

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

sp_addmergesubscription

sp_changemergesubscription

sp_helpmergesubscription

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.