exec sp_changedbowner 'Aambriore\mra'
EXEC sp_change_users_login 'Auto_Fix', 'lts', null
Exec sp_change_users_login 'Auto_Fix','dbo'
EXEC sp_change_users_login 'Update_One', 'dbo', 'Aambriore\mra'
select SID, [name] from master..sysxlogins
select [name], sid from sysusers
exec sp_fixusers
exec sp_changedbowner 'sa'
exec sp_change_users_login 'report'
SELECT UserName = name FROM sysusers
WHERE issqluser = 1 and (sid is not null and sid <> 0x0)
and suser_sname(sid) is null
and name in(select name from master.dbo.syslogins)
ORDER BY name
