-- exec dbo.sp_srvrolepermission

create table #t
( ServerRole sysname, Permission sysname)

insert into #t
exec sp_srvrolepermission

select * from #t where Permission like 'dbcc %'

drop table #t
go

-- exec dbo.sp_dbfixedrolepermission

create table #t
( DbFixedRole sysname, Permission sysname)

insert into #t
exec sp_dbfixedrolepermission

select * from #t where Permission like 'dbcc %'

drop table #t
go