Return All Database Users Which doesn’t Map to any Server login

Solution

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’)