Home Forums SQL Server 7,2000 Replication Cannot drop the database XXX because it is being used for replication. RE: Cannot drop the database XXX because it is being used for replication.
Jerrin
SSC Veteran
Points: 254
More actions
February 10, 2008 at 10:24 pm
#776800
write this and then try to update the system table
sp_configure 'allow updates',1
reconfigure with override
Then after the update execute this
sp_configure 'allow updates',0