Thank you for the information. I like the code and am going to test, however when I run the EXEC sp_change_users_login 'Report' on a database with several users, connected to a login or not, it doesn't return any records. I ran the code on master and several different databases (SQL 2014 and SQL 2016) all with Users. This is so simple I can't imagine what I am missing but obviously I am .