While you can use sp_validatelogins to find out if there are any sql login's that are orphaned (not mapped to valid windows account) the only process Micorsoft offers is what you've already guessed...dropping the orphaned login, and creating a new one.
Painting windows two colors allows your windows to pop like eyeliner on a woman’s eyes. However, when painting windows using two colors, you need to better understand the parts of the window and know what to watch out for.
Then when the FO retires or quits, the SID of the "financial_officer" login could be swapped out to immediately provide the privileges of the old FO to the new FO.
It was my hope that User_Created_Server_Level_Roles&UCSRL/SLR) (something I suggested to MS) would enable this ability, and it can, but only if a single login can be added to a UCSLR.
You have a window sash and a window casing that holds in the sash. Both sash and casing must be sized proportionally to make a visually pleasing impact on a building.
We showed you an example above of what to do and not to do when you are painting your windows.