sp_dropmergepublication
Drops a merge publication and its associated Snapshot Agent. All subscriptions must be dropped before dropping merge publications. The articles in the publication are dropped automatically. This stored procedure is executed at the Publisher on the publication database.
Syntax
sp_dropmergepublication [ @publication = ] 'publication'
[ , [ @ignore_distributor = ] ignore_distributor ]
[ , [ @reserved = ] reserved ]
Arguments
[@publication = ] 'publication'
Is the name of the publication to drop. publication is sysname, with no default. If all, all existing merge publications are removed as well as the snapshot associated with them. If other values are specified, the Snapshot Agent associated with that publication is dropped.
[@ignore_distributor = ] ignore_distributor
ignore_distributor is bit, with a default of 0. This parameter can be used to drop a publication 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_dropmergepublication is used in merge replication.
Permissions
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergepublication.