Thursday, March 8, 2012

Can't delete database that has been part of replication

I had a publication (merge) setup for a database. Deleted the publication and tried to delete the database. Sql server says it can't be deleted because it's has replication setup. Bug?

Found the answer. I had to run a stored procedure to get all replication objects removed from my db.

sp_removedbreplication @.dbname = 'dbname', @.type = 'merge'

/Magnus

No comments:

Post a Comment