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.
Thursday, December 01, 2016
Unable to delete Publication in SQL - Principal dbo does not exist
Labels:
Replication
,
SQL
,
SQL 2016
,
SSMS
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment