With the announced deprecation of sp_change_users_login
, how are we to use ALTER LOGIN to fix orphaned users, in the same way that I used to use
sp_change_users_login 'update_one','mary','mary'
Edit: Matt Whitfield pointed out I should have been talking about ALTER USER. My bad!