FixedServerRoles Enumeration

The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

public enum FixedServerRoles

Member nameDescription
NoneNo server role.
SysAdminCan control any aspect of the instance of Microsoft SQL Server.
ServerAdminCan alter Microsoft SQL Server settings, shut down the SQL Server Service, create and alter endpoints, alter the SQL Server state, and alter resources.
SetupAdminCan alter linked servers.
SecurityAdminCan alter logons.
ProcessAdminCan alter connections.
DBCreatorCan create databases.
DiskAdminCan alter resources.
BulkAdminAdministers bulk operations.

The FixedServerRoles class is served by the ServerConnection class.

Community Additions