Ninja Replication Settings

So you may have gathered from other posts that we are doing quite a bit of server relocations etc etc.

At one point in time we had a sick little replication happening. Through trifling vendors and whining little babies (you will eat your parents in a bowl of chili) replication became broke as all hell.

The breakers of replication failed to do it properly so we had ninja replication settings creeping in the shadows and making things tough on an old kung fu master trying to clean up.

If you get complaints about databases and logins being used in replication just run the below command:

use [master]
exec sp_dropdistributor @no_checks = 1

This will drop distributions and disable replication.

Leave a Reply

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