Hello Again,

sys.server_principals gives you the Server Logins and sys.database_principals gives you the DB Users in the selected DB.

Joining on the sid gives you the mapping (for one DB) e.g. Select * From sys.server_principals ssp Inner Join sys.database_principals sdb On (sdb.sid = ssp.sid)

Regards,

John Marsh