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.
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.
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
Really a awesome blog for the freshers. Thanks for posting the information.
ReplyDeleteIoT Training in Chennai
IoT Training
Data Analytics Courses in Chennai
Informatica MDM Training in Chennai
Hadoop Admin Training in Chennai
German Language Course in Chennai
content writing course in chennai
IoT Training in Velachery
IoT Training in Tambaram
Great Article
ReplyDeleteData Mining Projects
Python Training in Chennai
Project Centers in Chennai
Python Training in Chennai
Nice post.
ReplyDeleteDynamic CRM online training
Dynamic CRM training
Ethical hacking online training
Ethical hacking training
Informatica Data Quality online training
Informatica Data Quality training
Informatica idq online training
Informatica idq training
Informatica mdm online training
Informatica mdm training
Informatica message Queue online training
Informatica message Queue training
Informatica power center online training
Informatica power center training
Manual Testing online training
Manual Testing training
Microservices online training
Microservices training
It’s a free and easy to use trading app
ReplyDeleteStock market trading apps in India
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.
ReplyDeleteThat's Great & Giving so much information after reading your blog.
ReplyDeletebest equity broker in india
ReplyDeletehttps://www.chihuahuapuppiesforsale1.com/
http://www.myppuphouse.com/
https://www.yorkiespuppiessale.com/
https://chowchowpuppiessale.com/
http://www.globalkittens.com/
Is a Yorkie good dog family ?
ReplyDeleteyorkie 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.