sp_change_users_login

Back To Basics: How do I use sp_change_users_login?

The sp_change_users_login procedure has a specific purpose.  It's used to identify and correct users within a database which do not have a corresponding logins. You can specify the value of Report for the @Action input parameter to see any users which do not have a corresponding login.  This...