Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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