FixedServerRoles Enumeration

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

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

[FlagsAttribute] 
public enum FixedServerRoles
/** @attribute FlagsAttribute() */ 
public enum FixedServerRoles
FlagsAttribute 
public enum FixedServerRoles

Member nameDescription
BulkAdminAdministers bulk operations.
DBCreatorCan create databases.
DiskAdminCan alter resources.
NoneNo server role.
ProcessAdminCan alter connections.
SecurityAdminCan alter logons.
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.
SysAdminCan control any aspect of the instance of Microsoft SQL Server.

The FixedServerRoles class is served by the ServerConnection class.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show: