sp_removedistpublisherdbreplication (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_removedistpublisherdbreplication (Transact-SQL)

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.

Topic link icon Transact-SQL Syntax Conventions

sp_removedistpublisherdbreplication [ @publisher = ] 'publisher' 
        , [ @publisher_db = ] 'publisher_db'

[ @publisher= ] 'publisher'

Is the name of the Publisher server. publisher is sysname, with no default.

[ @publisher_db= ] 'publisher_db'

Is the name of the publication database. publisher_db is sysname with no default.

0 (success) or 1 (failure)

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.

Only members of the sysadmin fixed server role at the Distributor or members of the db_owner fixed database role in the distribution database can execute sp_removedistpublisherdbreplication.

Community Additions

© 2016 Microsoft