Search notes:

SQL Server: sp_helpsrvrole

sp_helpsrvrole lists the fixed server roles (except public which is internally not implemented as a role).
exec sp_helpsrvrole

ServerRole                          Description
----------------------------------- -----------------------------------
sysadmin                            System Administrators
securityadmin                       Security Administrators
serveradmin                         Server Administrators
setupadmin                          Setup Administrators
processadmin                        Process Administrators
diskadmin                           Disk Administrators
dbcreator                           Database Creators
bulkadmin                           Bulk Insert Administrators

See also

sp_helpdbfixedrole lists the fixed database roles.

Index