Below is a quick and easy way to query SQL Server 2005 system views to determine which users belong to which database roles on your SQL Server databases.

SELECT
      rolename = rolep.name,
      membername = memp.name
FROM
      sys.database_role_members rm
      JOIN sys.database_principals rolep ON rm.role_principal_id = rolep.principal_id
      JOIN sys.database_principals memp ON rm.member_principal_id = memp.principal_id

To determine which users are members of your server level roles on your instance, see this article.