SQL Server · 2016-03-19

TSQL – Orphaned User Script

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