Reset SQL Server User Login

From Relyimah

Sometimes, when a database is restored, even though you have the same Logins on the server you are restoring to, the users are not restored. This is because the Logins don't have the same SID as the server you are restoring from. To reset the users to the desired logins, you will need to run the following stored procedure:

SQL Query:

EXEC sp_change_users_login 'UPDATE_ONE', 'DB_USER', 'SERVER_LOGIN'