Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Cannot drop the database XXX because it is being used for replication. Expand / Collapse
Author
Message
Posted Sunday, February 10, 2008 10:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 2, 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
Posted Friday, June 27, 2008 2:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 21, 2013 1:46 PM
Points: 2, Visits: 140
Hi,

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

Richard Yang
Post #525349
Posted Thursday, July 17, 2008 2:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:22 AM
Points: 4, Visits: 75
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
Posted Sunday, July 27, 2008 8:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, January 8, 2009 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 8, 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
Posted Wednesday, February 25, 2009 7:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, April 9, 2009 11:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, August 28, 2009 2:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 3, 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
Posted Tuesday, September 15, 2009 7:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
Go back and drop the data / log files since dropping an offline database doesn't delete these files.
Post #788117
Posted Monday, April 19, 2010 11:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 4, 2014 8:45 AM
Points: 47, Visits: 133
Taking it offline worked. Thanks for the post!
Post #906212
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse