丰镇市网站,长沙关键词优化公司电话,重庆价格信息网官网,视频网站开发策划书之前因为从VFP数据库中把数据导入到SQL SERVER2000中#xff0c;用DTS做了发布与复制数据库distribution #xff0c;现在要把它删除#xff0c;当在企业管理器中执行删除时#xff0c;提示下面的错误#xff1a;Error 3724: cannot drop the database distribution becau…之前因为从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,1reconfigure with overridegoupdate master..sysdatabases set category 0 where namedistributiondelete the distribution database执行了上面的命令就可以在企业管理器中删除distribution数据库了。二、方法讨论1、如果你只执行这条命令update master..sysdatabases set category 0 where namedistribution会出现错误Ad hoc updates to system catalogs are not enabled. The system administratormust reconfigure SQL Server to allow this.所以你在必须先执行sp_configure allow updates,1reconfigure with overridego这条命令允许更新上面的错误才能解决。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参考英文资料http://www.ureader.com/message/145316.aspxhttp://support.default.aspx?scidkb;en-us;326352