Roles

SELECT dp.name,su.name FROM sys.database_principals dp 

inner join sys.database_role_members drm ON dp.principal_id= drm.member_principal_id

inner join sysusers su ON su.uid = drm.role_principal_id

--WHERE dp.name like '%nesk\pir%'