--查看當前分發服務器屬性USE masterEXEC sp_helpdistributor--查看當前發布服務器屬性USE masterEXEC sp_helpdistpublisher--徹底刪除發布和分發DECLARE @distributionDB AS sysname;DECLARE @publisher AS sysname;DECLARE @publicationDB as sysname;SET @distributionDB = N'distribution';SET @publisher = N'MyPublisherNm';SET @publicationDB = N'AdventureWorks2012';-- 刪除發布數據庫.USE [AdventureWorks2012]EXEC sp_removedbreplication @publicationDB;-- 從分發服務刪除注冊的本地發布.USE masterEXEC sp_dropdistpublisher @publisher;-- 刪除分發數據庫.EXEC sp_dropdistributiondb @distributionDB;-- 刪除分發服務.EXEC sp_dropdistributor;