Ninja Replication Settings Part 2! The Revenge

Even though ninjas are totally sweet and its pretty much a fact, sometimes having ninja settings in your system can be annoying and well…bothersome for productivity.

We had a developer who kept receiving an error when trying to alter table structures…the error basically said that the database could not be changed while set for replication. Of course, you cant alter structures that are published articles…this isnt out of the ordinary.

What was unusual was that the database did not have any active subscriptions, so trying to delete the publication (which came by way of mirror failover or restore) threw an error.

Long story short (few hours long)

sp_removedbreplication ‘DATABASENAME’

cuts like a razorblade


Leave a Reply

Your email address will not be published. Required fields are marked *