Hi I just wanted to quickly check that this does what I think it does, and has no nasty side effects.
I'm using the sp_change_users_login with the @Action = Update_one to change the Login name on a user, it seems to work but I'm a little confused by the help file and just wanted to know I haven't done anything really stupid.
It come back with the message:
The number of orphaned users fixed by updating users was 0.
which sounds good, I would want to orphane any of our users!