• 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" 😉