How to disable a Distributor (Transact-SQL)

To disable a Distributor

  1. Execute sp_dropdistpublisher to drop a Publisher that is also the Distributor.
  2. Execute sp_dropdistributiondb to delete the distribution database.
  3. Execute sp_dropdistributor to remove the Distributor designation from the server.
See Also
Disabling Publishing and Distribution sp_dropdistributor
sp_dropdistpublisher sp_dropdistributiondb

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.