I was fed up of manipulating sysusers after restoring a db from one server to another.Just put thgis script on QA after restoring db. It will check all db users (not tested for secure connections) and will restore orphan users. Check it out!Hope this script will help.
2003-02-03
823 reads
By James Serra
I get many of the same questions about Microsoft Purview, so I wanted to...
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
I posted a reply to a topic today and, after a minute or so,...
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers