sp_dropdistributor (T-SQL)

Uninstalls the Distributor.

Syntax

sp_dropdistributor [[@no_checks =] no_checks]
    [,[@ignore_distributor =] ignore_distributor

Arguments

[@no_checks =] no_checks

Indicates whether to check for dependent objects before dropping the Distributor. no_checks is bit, with a default of 0. If 0, sp_dropdistributor checks to make sure that all publishing and distribution objects in addition to the Distributor have been dropped. If 1, sp_dropdistributor drops all the publishing and distribution objects without checking.

[@ignore_distributor =] ignore_distributor

Indicates whether this stored procedure is executed without connecting to the Distributor. ignore_distributor is bit, with a default of 0. If 0, sp_dropdistributor connects to the Distributor and cleans up all replication objects. If sp_dropdistributor is unable to connect to the Distributor, the stored procedure fails. If 1, no connection is made to the Distributor and the replication objects are not cleaned up. This is used if the Distributor is being uninstalled or is permanently offline. The objects for this Publisher at the Distributor will not be cleaned up until the Distributor is reinstalled at some future time.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropdistributor is used in all types of replication.

If other Publisher or distribution objects exist on the server, sp_dropdistributor fails unless @no_checks is set to 1.

Permissions

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

See Also