Friday, January 17, 2014

Unable to delete replication publication


Problem


I'm trying to delete a publication and I'm getting the error message above.

Solution
Execute this SQL statement:

use [DatabaseName] EXEC sp_changedbowner 'sa'

Cause
I had copied this database from a test server and restored it in my dev environment. It changed the db owner to the user I was logged into when I did that. Thus running that sql statement changes the database owner back to the correct owner (in my case, it is 'sa')

No comments:

Post a Comment

There was an error in this gadget