Query to find Server Roles and its members in SQL Server 2000

select ‘ServerRole’= spv.name, ‘MemberName’= lgn.name

from master.dbo.spt_values spv,

master.dbo.sysxlogins lgn

where spv.low = 0 and spv.type=‘SRV’

and lgn.srvid IS NULL and spv.number & lgn.xstatus = spv.number;

MvM