sp-dropdistpublisher-transact-sql.md

title	sp_dropdistpublisher (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	sp_dropdistpublisher sp_dropdistpublisher_TSQL
helpviewer_keywords	sp_dropdistpublisher
ms.assetid	c0bdd3de-3be0-455c-898a-98d4660e7ce3
author	stevestein
ms.author	sstein

sp_dropdistpublisher (Transact-SQL)

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]

Drops a distribution Publisher. This stored procedure is executed at the Distributor on any database.

Transact-SQL Syntax Conventions

Syntax

  
sp_dropdistpublisher [ @publisher = ] 'publisher'  
    [ , [ @no_checks = ] no_checks ]  
    [ , [ @ignore_distributor = ] ignore_distributor ]  

Arguments

[ @publisher = ] 'publisher' Is the Publisher to drop. publisher is sysname, with no default.

[ @no_checks = ] no_checks Specifies whether sp_dropdistpublisher checks that the Publisher has uninstalled the server as the Distributor. no_checks is bit, with a default of 0.

If 0, replication verifies that the remote Publisher has uninstalled the local server as the Distributor. If the Publisher is local, replication verifies that there are no publication or distribution objects remaining on the local server.

If 1, all the replication objects associated with the distribution Publisher are dropped even if a remote Publisher cannot be reached. After doing this, the remote Publisher must uninstall replication using sp_dropdistributor with @ignore_distributor = 1.

[ @ignore_distributor = ] ignore_distributor Specifies whether distribution objects are left at the Distributor when the Publisher is removed. ignore_distributor is bit and can be one of these values:

1 = distribution objects belonging to the publisher remain at the Distributor.

0 = distribution objects for the publisher are cleaned-up at the Distributor.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropdistpublisher is used in all types of replication.

When dropping an Oracle Publisher, if unable to drop the Publisher sp_dropdistpublisher returns an error and the Distributor objects for the Publisher are removed.

Example

[!code-sqlHowTo#sp_DropDistPub]

Permissions

Only members of the sysadmin fixed server role can execute sp_dropdistpublisher.

See Also

Disable Publishing and Distribution
sp_adddistpublisher (Transact-SQL)
sp_changedistpublisher (Transact-SQL)
sp_helpdistpublisher (Transact-SQL)
Replication Stored Procedures (Transact-SQL)