How To
How To Disable Publishing and Distribution (Transact-SQL)
To disable a Distributor (Transact-SQL)
- Execute sp_dropdistpublisher to drop a Publisher that is also the Distributor.
- Execute sp_dropdistributiondb to delete the distribution database.
- 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.