Friday, March 9, 2012

Replication --> Error 21122: Cannot drop destination database...

Good day!

I am getting a bizard error here...

I am trying to drop replication off a database, and funny enough went trough all the steps and I am still getting the error when I try to Disable publishing.

I also did an EXEC sp_removedbreplication 'databasename'

Any ideas?Was able to find the error...

It's all about who initially created the replication or a rights issue. In this case the owner (of the replication) needs to be the one deleting it.

No comments:

Post a Comment