title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_dropdistributor (Transact-SQL) |
Uninstalls the Distributor. This stored procedure is executed at the Distributor on any database except the distribution database. |
markingmyname |
maghan |
randolphwest |
11/28/2023 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server SQL MI]
Uninstalls the Distributor. This stored procedure is executed at the Distributor on any database except the distribution database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_dropdistributor
[ [ @no_checks = ] no_checks ]
[ , [ @ignore_distributor = ] ignore_distributor ]
[ ; ]
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 were dropped, in addition to the Distributor. -
If
1
,sp_dropdistributor
drops all the publishing and distribution objects before uninstalling the 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 removes all replication objects. Ifsp_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 aren't removed. This option is used if the Distributor is being uninstalled or is permanently offline. The objects for this Publisher at the Distributor aren't removed until the Distributor is reinstalled at some future time.
0
(success) or 1
(failure).
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
.
This stored procedure must be executed after dropping the distribution database by executing sp_dropdistributiondb
.
:::code language="sql" source="../replication/codesnippet/tsql/sp-dropdistributor-trans_1.sql":::
Only members of the sysadmin fixed server role can execute sp_dropdistributor
.