List Server Roles

I am currently working on a SSIS configuration database. However, I am having trouble writing a script to get the the users that have each server role permissions. I'm pretty sure that I need to use sp_helpsrvrole, but am not sure where to go from here. If anybody has any ideas or has seen a script on the internet to get this then that would be a tremendous help.

Thanks in advance,

Kyle

Please try:

exec sp_helpsrvrolemember

this should get the server role membership information you are looking for. Let us know if you have any further questions.

-Raul Garcia

SDE/T

SQL Server Engine

List of users + roles + rights

How can I generate a list/view of all users/groups with appropriate roles and rigths?SP_HELPROTECT list all the information in the database.|||Hi,
Can someone please let me know if there is some way to find out the roles of a user in SQL server 2000?
The sysusers table has a column called roles that stores a bit set for every role associated with the user. But given a user name / uid how to find out all the roles (role ids will do) associated with that user?
Please help ... its urgent.
Thanks for your time,
Sayali|||In SQL-2000, this is stored in sysmembers (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-m_6f3n.asp).

-PatP