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
 

27 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
  6. Independent Escorts in Dubai is the right decision. the top Dubai Escorts at your one Click. Log on to us for entertainment.

    ReplyDelete
  7. Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday. It’s always useful to read through content from other authors and use something from other sites. 메이저안전놀이터

    ReplyDelete
  8. That's Great & Giving so much information after reading your blog.

    best equity broker in india

    ReplyDelete