select
sl.name,
sl.fullname,
ssr.name
from sysloginroles slr
join syslogins sl on sl.suid = slr.suid
join syssrvroles ssr on slr.srid = ssr.srid and ssr.name = 'lis_rx'

use master
go
select
sl.name,
sl.fullname,
ssr.name,
case sp.action when 151 then 'references'
when 193 then 'select'
when 195 then 'insert'
when 196 then 'delete'
when 197 then 'update'
when 224 then 'execute'
else convert(varchar(10), sp.action ) end as action,
so.name
from sysloginroles slr
join syslogins sl on sl.suid = slr.suid
join syssrvroles ssr on slr.srid = ssr.srid
join <Имя БД>..sysusers su on su.name = ssr.name
join <Имя БД>..sysprotects sp on sp.uid = su.uid and ssr.name = <Имя роли>
join <Имя БД>.sysobjects so on so.id = sp.id