sys.sp_removedistpublisherdbreplication

Description

Removes publishing metadata belonging to a specific publication at the Distributor. This stored procedure is executed at the Distributor on the distribution database.

Syntax

sp_removedistpublisherdbreplication

Permissions

is used when a published database must be recreated without also dropping the distribution database. The following metadata is removed: All publication metadata. Metadata for all articles belong to the publication. Metadata for all subscriptions to the publication. Metadata for all replication agent jobs that belong to the publication. Only members of the fixed server role at the Distributor or members of the fixed database role in the distribution database can execute. System stored procedures (Transact-SQL)

Remarks

Removes publishing metadata belonging to a specific publication at the Distributor. This stored

procedure is executed at the Distributor on the distribution database.

The name of the Publisher server.

, with no default.

The name of the publication database.

@publisher_db

, with no default.

(success) or

is used by transactional and snapshot replication.