• This is what I personally use

    select 'exec sp_change_users_login ''AUTO_FIX'',''' + [name] + '''', * from sysusers where status != 0 and uid > 2

    it builds a string for each account, then I take and run the resultset in another window.