Finding Orphaned Users

USE [db]
GO
EXEC sp_change_users_login 'Report'
GO

Fixing Orphaned Users

USE [db]
GO
EXEC sp_change_users_login 'auto_fix', 'USERNAME'
GO