I always use sp_change_users_login in these circumstances, so had to pick an answer at random, luckily I got the right one :).

I wonder why they are withrawing this procedure? Anyone know if the replacement command does all the security checking that the procedure does?