To fix all user Maping

Solution

where username=loginname
DECLARE @orphanuser varchar(50)
DECLARE Fix_orphan_user CURSOR FOR
SELECT dp.name As Orphan_Users
FROM sys.database_principals dp
left join sys.server_principals sp
ON dp.sid=sp.sid
WHERE sp.name IS NULL
AND dp.type=’S’ AND
dp.name NOT IN (‘guest’,’INFORMATION_SCHEMA’,’sys’)

OPEN Fix_orphan_user
FETCH NEXT FROM Fix_orphan_user
INTO @orphanuser WHILE @@FETCH_STATUS = 0
BEGIN

EXECUTE(‘ALTER USER ‘ + @orphanuser + ‘ WITH LOGIN = ‘ + @orphanuser)

FETCH NEXT FROM Fix_orphan_user
INTO @orphanuser
END
CLOSE Fix_orphan_user
DEALLOCATE Fix_orphan_user