How to show SQL server 2000 server roles through an SQL query

Question

what sql query will i need to show the activated server roles in a specific user?

Answer 1

EXEC sp_helpuser 'username' should do.

Answer 2

THIS SHOULD DO IT:

select 'ServerRole' = spv.name, 'MemberName' = lgn.name, 'MemberSID' = lgn.sid 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