Cannot drop the database XXX because it is being used for replication.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Cannot drop the database XXX because it is...

22 posts, Page 2 of 3

««1 2 3 »»

Cannot drop the database XXX because it is being used for replication.

Rate Topic

Display Mode

Topic Options

Author

Message

Jerrin

Posted Sunday, February 10, 2008 10:24 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 6:52 AM
Points: 158, Visits: 52

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
reconfigure with override

Post #453723

ryang9639@yahoo.com

Posted Friday, June 27, 2008 2:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 27, 2012 10:41 AM
Points: 2, Visits: 104

Hi,

Try to setup Server Seeting-> Server behaiver->allow modifications to be made directly to system catalogs

Richard Yang

Post #525349

shah797

Posted Thursday, July 17, 2008 2:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 11:44 AM
Points: 4, Visits: 64

This will let you update. This is dangerous so make sure to run allow updates 0

sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO

update sysdatabases set category=0 where name = 'xxx'

sp_configure 'allow updates',0
GO
RECONFIGURE WITH OVERRIDE
GO

Post #536304

GrahamO-735217

Posted Sunday, July 27, 2008 8:34 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, July 28, 2008 8:36 PM
Points: 11, Visits: 41

Is this any help?
http://www.dbforums.com/showthread.php?t=708918

Graham Okely B App Sc
Senior Database Administrator

Post #541588

achir.lui

Posted Thursday, January 08, 2009 3:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 08, 2009 3:24 AM
Points: 1, Visits: 1

I got the same problem.I tried to solved it.Then I checked "Replication" item,found that I set up the Publications rule for the detached database.So you can check the Publication and Subscriptions.

Post #632209

phillip_latham

Posted Wednesday, February 25, 2009 7:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 28, 2012 2:08 PM
Points: 1, Visits: 57

Hello, you need to run the following:

sp_configure "allow updates", 1
go
Reconfigure with override
go

After you execute the failing command:

sp_configure "allow updates", 0
go
Reconfigure with override
go

Hope this helps.

Todd

Post #664210

lyhe

Posted Thursday, April 09, 2009 11:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 11:58 AM
Points: 1, Visits: 28

Taking the database offline works like a charm. Thanks raja

Post #694312

rafael.algora

Posted Friday, August 28, 2009 2:06 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, August 03, 2010 7:40 AM
Points: 13, Visits: 24

You must use the next:

use master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO

to allow updates over system databases

When you finish the operation, yo must run the next:

use master
GO
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO

Post #778932