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
 

12 comments:

  1. Algo trading is the new popular trading mechanism in the Indian stock market for Algo trading profits.

    ReplyDelete
  2. Thanks for the nice information. Bajaj finance share price is now on good position

    ReplyDelete
  3. Indira Securities is one of the best commodity broker in Indore. The company offers open commodity trading account online and traders community which helps them save on brokerage.

    ReplyDelete
  4. Indira Securities is top online stock broking company in Indore, India. You can use our premium services for intraday trading by opening a demat account with us.

    ReplyDelete
  5. Indira Securities is top online stock broking company in Indore, India. You can use our premium services for intraday trading by opening a demat account with us.

    ReplyDelete