Msg 15404, Level 16, State 19, Procedure sp_replcmds, Line 1

Today when I was trying to drop publisher for replication that I had set up for one of the SQL Server database by using below script, got error.

use [YourDataBaseName]
exec sp_droppublication @publication = N'PublisherName'
GO

Msg 15404, Level 16, State 19, Procedure sp_replcmds, Line 1
Could not obtain information about Windows NT group/user 'username', error code 0x5.



To solve this problem you have to check the owner of database and then change the ownership to sa by using below statement.

ALTER AUTHORIZATION ON DATABASE::YourDataBaseName to sa
 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.