The stored procedure sp_change_users_login used to fix Orphaned SQL Server users.

Microsoft says this feature will be removed in a future version of Microsoft SQL Server. so instead of using this sp start using ALTER USER command.