Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Removes publishing metadata belonging to a specific publication at the Distributor. This stored procedure is executed at the Distributor on the distribution database.
sp_removedistpublisherdbreplication is used by transactional and snapshot replication.
sp_removedistpublisherdbreplication 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.