Richard Fryar (2/8/2013)
This script checks all databases in one go, and avoids use of a cursor.
Have you seen the code for sp_MSForeachdb????
SQLCrazyCertified (2/8/2013)
Is it going through each database that I failover and checking for orphan users and fixing them at the same time?SueTons.
No it's going through every user database on the instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉