I restored a backup of a replication database named "distribution" to a non-replicated development instance (ss2000). Well, when I try to drop the database I am told I can not because it is used for replication. It isn't. But you now how Microsoft is . . . . So the question is: how do I drop the database without rebuilding the server, or jumping through firery hoops?
Thanks!
Scorched
First do this you bonehead!!sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GO
Then you can update the sysdatabases.category = 0
Drop away!
No comments:
Post a Comment