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)
Syntax
'Declaration
<FlagsAttribute> _
Public Enumeration FixedServerRoles
[FlagsAttribute]
public enum FixedServerRoles
[FlagsAttribute]
public enum class FixedServerRoles
/** @attribute FlagsAttribute() */
public enum FixedServerRoles
FlagsAttribute
public enum FixedServerRoles
Members
| Member name | Description |
|---|---|
| BulkAdmin | Administers bulk operations. |
| DBCreator | Can create databases. |
| DiskAdmin | Can alter resources. |
| None | No server role. |
| ProcessAdmin | Can alter connections. |
| SecurityAdmin | Can alter logons. |
| ServerAdmin | Can alter Microsoft SQL Server settings, shut down the SQL Server Service, create and alter endpoints, alter the SQL Server state, and alter resources. |
| SetupAdmin | Can alter linked servers. |
| SysAdmin | Can control any aspect of the instance of Microsoft SQL Server. |
Remarks
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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
Microsoft.SqlServer.Management.Common Namespace