Fixing Orphaned Database Users : sp_change_users_login « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_change_users_login

SELECT s.name LoginName, d.name DbName, d.sid
FROM sys.database_principals d
INNER JOIN sys.server_principals s ON
d.sid = s.sid
WHERE s.name = 'YourName'

EXEC sp_change_users_login 'Report'

EXEC sp_change_users_login 'Auto_Fix', 'Danny', NULL, 'newDannypassword!#@'