Constantine Kokkinos shows a built-in stored procedure which shows login mappings to database users:
A great little built in stored procedure to map server level logins to database users named sp_msloginmappings .
It builds one result set per login, so you might be getting a lot of result sets back.