Thursday, December 01, 2016

Unable to delete Publication in SQL - Principal dbo does not exist

I found that I couldn't delete a publication in SQL this morning.  Turns out the database needed to have an owner before you can delete a publication.

Sure enough, specifying an owner to the database then allows me to remove publications.

Source:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/44144690-d47b-43a3-b460-cee1f71279a3/could-not-delete-publication?forum=sqlreplication

If you find this article useful please leave me a comment.

No comments :

Post a Comment