One-liner: sp_change_users_login

To automatically map users to the SQL logins on the server:

exec sp_change_users_login ‘Auto_fix’

To find orphaned users ( users with no logins):

Use
exec sp_change_users_login @Action = ‘Report’

Reference: BOL

Advertisement