EXEC sp_change_users_login 'auto_fix', 'prod1'
Later versions of SQL like this better:
EXEC sp_change_users_login 'auto_fix', 'prod1', NULL, 'prod1'