Fixing Orphaned Users in SQL Server

One of the first tasks when loading data from a backup is to match up the
users in the database with the ones defined in SQL Server. Getting data
from clients continually and having to do this you would think I would
remember it but unfortunately no, I have to lookup it up each time.

So this one is mainly for me!!!

EXEC sp_change_users_login 'Update_One', 'john', 'john'

Leave a comment