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
 

8 comments:

  1. 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
  2. That's Great & Giving so much information after reading your blog.

    best equity broker in india

    ReplyDelete

  3. https://www.chihuahuapuppiesforsale1.com/
    http://www.myppuphouse.com/
    https://www.yorkiespuppiessale.com/
    https://chowchowpuppiessale.com/
    http://www.globalkittens.com/



    ReplyDelete
  4. Is a Yorkie good dog family ?
    yorkie puppies for sale
    Yorkies, like many other Toy breeds, make good pets for people; they're especially good for senior citizens, people with medical issues, and those who may worry about the size and strength of a larger dog. ... They're loving, devoted, and very affectionate: This makes them great personal companions and good family pets.

    Do Yorkshire terriers bark a lot?
    teacup yorkie for sale
    Yorkshire Terriers are little dogs with huge personalities. yorkies for sale With those huge personalities come a fierce territorial bark. Any time your phone rings, someone speaks or knocks on your door, or your doorbell chimes, your Yorkshire Terrier will likely bark. Outside noises aren't even required for barking for some Yorkies. yorkie for sale near me

    How much do Yorkshire terriers cost?
    yorkies puppy for sale
    Typical Yorkie prices range from $1,500 to $3,000, but the cost can fall far below or above that range. Prices will vary based on the puppy's lineage, appearance, health, and the breeder. It's also possible to adopt an older Yorkie for significantly less through a rescue shelter.

    ReplyDelete