之前因为从VFP数据库中把数据导入到SQL SERVER2000中，用DTS做了发布与复制数据库\'distribution\'，现在要把它删除，当在企业管理器中执行删除时，提示下面的错误：

Error 3724: cannot drop the database \'distribution\'because it is being used for replication.

解决方法：

一、首先要备份 master 数据库，在查询分析器选择 master 数据库下操作：

sp_configure \'allow updates\',1
reconfigure with override
go

update master..sysdatabases set category = 0 where name=\'distribution\'

delete the distribution database

执行了上面的命令，就可以在企业管理器中删除\'distribution\'数据库了。

二、方法讨论：

1、如果你只执行这条命令：update master..sysdatabases set category = 0 where name=\'distribution\'

会出现错误：Ad hoc updates to system catalogs are not enabled. The system administrator
must reconfigure SQL Server to allow this.

所以你在必须先执行：

sp_configure \'allow updates\',1
reconfigure with override
go

这条命令允许更新，上面的错误才能解决。

2、也可以移除，自己翻译一下 ^_^： Make sure that you did not enable this database for replication by using the sp_helpreplicationdboption system stored procedure. Do not enable the database for replication. If it is enabled for replication, run the sp_removedbreplication stored procedure to disable replication.

IMPORTANT: Running sp_removedbreplication on a database removes all replication objects from the database. Therefore, all publications and subscriptions in the database are removed. Only members of the sysadmin fixed server role can run the sp_removedbreplication stored procedure. For more information about the sp_removedbreplication stored procedure, see the \"sp_removedbreplication, Transact-SQL Reference\" topic in SQL Server Books Online.

To run the sp_removedbreplication stored procedure, use the following code in which you replace dbname with the name of your database:

执行命令： sp_removedbreplication \'distribution\'