How To Disable Publishing and Distribution (Transact-SQL)

How to Install SQL Server 2000

How To

How To Disable Publishing and Distribution (Transact-SQL)

To disable a Distributor (Transact-SQL)

  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.

To delete a distribution database (Transact-SQL)

  • Execute sp_dropdistributiondb to delete a distribution database.

To manually remove replication on a Publisher without connecting to the Distributor (Transact-SQL)

  • Execute sp_dropdistributor with @no_checks=1 and @ignore_distributor=1.