• Article

IServerConfigurationFacet Members

Include Protected Members
Include Inherited Members

Contains configuration information for the interface based on Configuration

The IServerConfigurationFacet type exposes the following members.

Properties

  Name Description
Public property AdHocRemoteQueriesEnabled Gets or sets a Boolean value that specifies if ad hoc remote queries are enabled.
Public property Affinity64IOMask Gets the affinity64 IO mask for a server.
Public property Affinity64Mask Gets the affinity64 mask for a server.
Public property AffinityIOMask Gets the affinity IO mask for a server.
Public property AffinityMask Gets the affinity mask for a server.
Public property AgentXPsEnabled Gets or sets a Boolean value that specifies if the SQL Server Agent extended stored procedures are enabled.
Public property AllowUpdates Gets or sets a Boolean value that specifies specifying if the allow updates option is set.
Public property AweEnabled Gets a Boolean value that specifies if the awe enabled value is set.
Public property BlockedProcessThreshold Gets or sets the blocked process threshold.
Public property C2AuditTracingEnabled Gets a Boolean value that specifies if the C2 audit tracing is set.
Public property ClrIntegrationEnabled Gets or sets a Boolean value that specifies if the CLR integration value is set.
Public property CommonCriteriaComplianceEnabled Gets a Boolean value that specifies if the common criteria compliance value is set.
Public property CostThresholdForParallelism Returns the value contained in the cost threshold for parallelism property.
Public property CrossDBOwnershipChainingEnabled Gets or sets a Boolean value that specifies if the cross DBOwnership chaining value is set.
Public property CursorThreshold Gets or sets the cursor threshold value.
Public property DatabaseMailEnabled Gets a Boolean value that specifies if the DatabaseMailEnabled property is set.
Public property DefaultBackupCompressionEnabled Gets or sets a Boolean value that specifies if the BackupCompressionEnabled option is set.
Public property DefaultFullTextLanguage Gets or sets the DefaultFullTextLanguage property.
Public property DefaultLanguage Gets or sets the DefaultLanguage property.
Public property DefaultTraceEnabled Gets or sets a Boolean value that specifies if the DefaultTraceEnabled property is set.
Public property DisallowResultsFromTriggers Gets or sets a Boolean value that specifies if the DisallowResultsFromTriggers property is set.
Public property DynamicLocks Gets the value of the DynamicLocks property.
Public property ExtensibleKeyManagementEnabled Gets a Boolean value that specifies if the ExtensibleKeyManagementEnabled property is set.
Public property FilestreamAccessLevel
Public property FillFactor Gets the value of the FillFactor property.
Public property FullTextCrawlBandwidthMax Gets or sets the value of the FullTextCrawlBandwidthMax property.
Public property FullTextCrawlBandwidthMin Gets or sets the value of the FullTextCrawlBandwidthMin property.
Public property FullTextCrawlRangeMax Gets or sets the value of the FullTextCrawlRangeMax property.
Public property FullTextNotifyBandwidthMax Gets or sets the value of the FullTextNotifyBandwidthMax property.
Public property FullTextNotifyBandwidthMin Gets or sets the FullTextNotifyBandwidthMin property value.
Public property IndexCreateMemory Gets or sets the IndexCreateMemory property value.
Public property InDoubtTransactionResolution Gets or sets the InDoubtTransactionResolutionType property value.
Public property LightweightPoolingEnabled Gets a Boolean value that specifies if the LightweightPoolingEnabled property value is set.
Public property MaxDegreeOfParallelism Gets or sets the MaxDegreeOfParallelism property value.
Public property MaxServerMemory Gets or sets the MaxServerMemory property value.
Public property MaxWorkerThreads Gets the MaxWorkerThreads property value.
Public property MediaRetention Gets the MediaRetention property value.
Public property MinMemoryPerQuery Gets or set the MinMemoryPerQuery property value.
Public property MinServerMemory Gets or sets the MinServerMemory property value.
Public property NestedTriggersEnabled Gets or sets a Boolean value that specifies if the NestedTriggersEnabled property value is set.
Public property NetworkPacketSize Gets or sets the NetworkPacketSize property value.
Public property OleAutomationEnabled Gets or sets a Boolean value that specifies if the OleAutomationEnabled property value is set.
Public property OpenObjects Gets the OpenObjects property value.
Public property OptimizeAdhocWorkloads
Public property PrecomputeRank Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set.
Public property PriorityBoost Gets or a Boolean value that specifies if the PriorityBoost property value is set.
Public property ProtocolHandlerTimeout Gets or sets the ProtocolHandlerTimeout property value.
Public property QueryGovernorCostLimit Gets or sets the QueryGovenorCostLimit property value.
Public property QueryWait Gets or sets the QueryWait property value.
Public property RecoveryInterval Gets or sets the RecoveryInterval property value.
Public property RemoteAccessEnabled Gets a Boolean value that specifies if the RemoteAccessEnabled property has been set.
Public property RemoteDacEnabled Gets or sets a Boolean value that specifies if the RemoteDacEnabled property is set.
Public property RemoteLoginTimeout Gets or sets the RemoteLoginTimeout property value.
Public property RemoteProcTransEnabled Gets or sets a Boolean value that specifies if the RemoteProcTransEnabled is set.
Public property RemoteQueryTimeout Gets or sets the RemoteQueryTimeout property value.
Public property ReplicationMaxTextSize Gets or sets the ReplicationMaxTextSize property value.
Public property ReplicationXPsEnabled Gets or sets a Boolean value that specifies if the ReplicationXPsEnabled property is set.
Public property ScanForStartupProcedures Gets or sets a Boolean value that specifies if the ScanForStartupProcedures property is set.
Public property ServerTriggerRecursionEnabled Gets or sets a Boolean value that specifies if the ServerTriggerRecursionEnabled property is set.
Public property SetWorkingSetSize Gets a Boolean value that specifies if the SetWorkingSetSize property value is set.
Public property ShowAdvancedOptions Gets or sets a Boolean value that specifies if the ShowAdvancedOptions property value is set.
Public property SmoAndDmoXPsEnabled Gets or sets a Boolean value that specifies if the SmoAndDmoSPsEnabled property value is set.
Public property SqlMailEnabled Gets or sets a Boolean value that specifies if the SqlMailEnabled property value is set.
Public property TransformNoiseWords Gets or sets a Boolean value that specifies if the TransformNoiseWords property value is set.
Public property TwoDigitYearCutoff Gets or sets the TwoDigitYearCutoff property value.
Public property UserConnections Gets the UserConnections property value.
Public property UserInstancesEnabled Gets or sets a Boolean value that specifies if the UserInstancesEnabled property value is set.
Public property UserInstanceTimeout Gets or sets the UserInstanceTimeout property value.
Public property UserOptions Gets or sets the UserOptions property value.
Public property WebAssistantEnabled Gets or sets a Boolean value that specifies if the WebAssistantEnabled property value is set
Public property XPCmdShellEnabled Gets or sets a Boolean value that specifies if the XPCmdShellEnabled property is set.

Top