Configuration Properties
| Name | Description | |
|---|---|---|
| AdHocDistributedQueriesEnabled |
Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.
|
|
| Affinity64Mask |
Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option.
|
|
| AffinityIOMask |
Gets the ConfigProperty object that is used to set the affinity IO mask configuration option.
|
|
| AffinityMask |
Gets the ConfigProperty object that is used to set the affinity mask configuration option.
|
|
| AgentXPsEnabled |
Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option.
|
|
| AllowUpdates |
Gets the ConfigProperty object that is used to set the allow updates configuration option.
|
|
| AweEnabled |
Gets the ConfigProperty object that is used to set the AWE enabled configuration option.
|
|
| C2AuditMode |
Gets the ConfigProperty object that is used to set the C2 audit mode configuration option.
|
|
| CostThresholdForParallelism |
Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.
|
|
| CrossDBOwnershipChaining |
Gets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.
|
|
| CursorThreshold |
Gets the ConfigProperty object that is used to set the cursor threshold configuration option.
|
|
| DatabaseMailEnabled |
Gets the ConfigProperty object that is used to set the database mail enabled configuration option.
|
|
| DefaultFullTextLanguage |
Gets the ConfigProperty object that is used to set default full text language configuration option.
|
|
| DefaultLanguage |
Gets the ConfigProperty object that is used to set the default language configuration option.
|
|
| FillFactor |
Gets the ConfigProperty object that is used to set the fill factor configuration option.
|
|
| IndexCreateMemory |
Gets the ConfigProperty object that is used to set the index create memory configuration option.
|
|
| IsSqlClrEnabled |
Gets the ConfigProperty object that is used to set the is SQL CLR enabled configuration option.
|
|
| LightweightPooling |
Gets the ConfigProperty object that is used to set the lightweight pooling configuration option.
|
|
| Locks |
Gets the ConfigProperty object that is used to set the locks configuration option.
|
|
| MaxDegreeOfParallelism |
Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option.
|
|
| MaxServerMemory |
Gets the ConfigProperty object that is used to set the max server memory configuration option.
|
|
| MaxWorkerThreads |
Gets the ConfigProperty object that is used to set the max worker threads configuration option.
|
|
| MediaRetention |
Gets the ConfigProperty object that is used to set the media retention configuration option.
|
|
| MinMemoryPerQuery |
Gets the ConfigProperty object that is used to set the min memory per query configuration option.
|
|
| MinServerMemory |
Gets the ConfigProperty object that is used to set the min server memory configuration option.
|
|
| NestedTriggers |
Gets the ConfigProperty object that is used to set the nested triggers configuration option.
|
|
| NetworkPacketSize |
Gets the ConfigProperty object that is used to set the network packet size configuration option.
|
|
| OleAutomationProceduresEnabled |
Gets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.
|
|
| OpenObjects |
Gets the ConfigProperty object that is used to set the open objects configuration option.
|
|
| Parent |
Gets the Server object that is the parent of the Configuration object.
(inherited from
ConfigurationBase
)
|
|
| PrecomputeRank |
Gets the ConfigProperty object that is used to set the precompute rank configuration option.
|
|
| PriorityBoost |
Gets the ConfigProperty object that is used to set the priority boost configuration option.
|
|
| Properties |
Returns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.
|
|
| ProtocolHandlerTimeout |
Gets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.
|
|
| QueryGovernorCostLimit |
Gets the ConfigProperty object that is used to set the query governor cost limit option.
|
|
| QueryWait |
Gets the ConfigProperty object that is used to set the query wait configuration option.
|
|
| RecoveryInterval |
Gets the ConfigProperty object that is used to set the recovery interval configuration option.
|
|
| RemoteAccess |
Gets the ConfigProperty object that is used to set the remote access configuration option.
|
|
| RemoteDacConnectionsEnabled |
Gets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.
|
|
| RemoteLoginTimeout |
Gets the ConfigProperty object that is used to set the remote login timeout configuration option.
|
|
| RemoteProcTrans |
Gets the ConfigProperty object that is used to set the remote proc trans configuration option.
|
|
| RemoteQueryTimeout |
Gets the ConfigProperty object that is used to set the remote query timeout configuration option.
|
|
| ReplicationMaxTextSize |
Gets the ConfigProperty object that is used to set the replication max text size configuration option.
|
|
| ReplicationXPsEnabled |
Gets the ConfigProperty object that is used to set the replication XPs enabled configuration option.
|
|
| ScanForStartupProcedures |
Gets the ConfigProperty object that is used to set the scan for startup procedures configuration option.
|
|
| SetWorkingSetSize |
Gets the ConfigProperty object that is used to set the set working set size configuration option.
|
|
| ShowAdvancedOptions |
Gets the ConfigProperty object that is used to set the show advanced options configuration option.
|
|
| SmoAndDmoXPsEnabled |
Gets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.
|
|
| SqlMailXPsEnabled |
Gets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.
|
|
| TransformNoiseWords |
Gets the ConfigProperty object that is used to set the transform noise words configuration option.
|
|
| TwoDigitYearCutoff |
Gets the ConfigProperty object that is used to set the two digit year cutoff configuration option.
|
|
| UserConnections |
Gets the ConfigProperty object that is used to set the user connections configuration option.
|
|
| UserOptions |
Gets the ConfigProperty object that is used to set the user options configuration option.
|
|
| WebXPsEnabled |
Gets the ConfigProperty object that is used to set the web XPs enabled configuration option.
|
|
| XPCmdShellEnabled |
Gets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option.
|
