SQL server loginname alias mapping problem.

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

转载于:https://www.cnblogs.com/yangbin990/archive/2006/02/17/332402.html