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
826 reads
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Hello SSC, I am not sure if I posted this in the right spot,...
What is a partial backup for a read-write database?
See possible answers