| Event Information | CAUSE:
A SQL Server instance that is configured as a Distributor cannot be removed from the role of Distributor because there are distribution databases associated with the instance.
RESOLUTION:
To find the names of any Publishers and distribution databases associated with this Distributor instance, execute helpdistpublisherfrom any database on the Distributor instance.
Execute sp_dropdistributiondb for any distribution databases associated with this Distributor. Once all distribution database associations are removed, you can reconfigure the SQL Server instance to not be a Distributor. |
