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

sp_dropmergepublication

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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.

sp_dropmergepublication cannot be executed from within a transaction.

Permissions

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

See Also

sp_addmergepublication

sp_changemergepublication

sp_helpmergepublication

System Stored Procedures

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