Displays the permissions of a fixed server role.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Applies to: SQL Server (SQL Server 2008 through current version).
The permissions listed include the Transact-SQL statements that can be executed, and other special activities that can be performed by members of the fixed server role. To display a list of the fixed server roles, execute sp_helpsrvrole.
The sysadmin fixed server role has the permissions of all the other fixed server roles.
The following query returns the permissions associated with the sysadmin fixed server role.
EXEC sp_srvrolepermission 'sysadmin'; GO