Returns a list of the SQL Server fixed server roles.
Fixed server roles are defined at the server level and have permissions to perform specific server-level administrative activities. Fixed server roles cannot be added, removed, or changed.
The following table shows stored procedures that can be used to modify server roles.
Adds a login account to a fixed server role.
Displays a list of the members of a fixed server role.
Removes a member of a server role.
The following query returns the list of available fixed server roles.