Export (0) Print
Expand All
Expand Minimize

IServerConfigurationFacet Properties

The IServerConfigurationFacet type exposes the following members.

  Name Description
Public property AdHocRemoteQueriesEnabled Gets or sets a Boolean value that specifies whether ad hoc remote queries are enabled.
Public property Affinity64IOMask Gets the affinity64 IO mask for a server.
Public property Affinity64Mask Gets or sets the affinity 64 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 whether 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 ContainmentEnabled Gets the value that indicates whether the containment is enabled.
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 Gets or sets the level of access permitted on the servers FILESTREAM operations.
Public property FillFactor Gets the value of the FillFactor property.
Public property FullTextCrawlBandwidthMax Gets or sets the maximum value of the full text crawl bandwidth.
Public property FullTextCrawlBandwidthMin Gets or sets the minimum value of the full text crawl bandwidth.
Public property FullTextCrawlRangeMax Gets or sets the maximum value of the full text crawl range.
Public property FullTextNotifyBandwidthMax Gets or sets the maximum value of the full text notify bandwidth.
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 or sets the media retention.
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 Gets or sets a value that determines whether ad hoc workloads will be optimized.
Public property PrecomputeRank Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set.
Public property PriorityBoost Gets 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 maximum estimated cost allowed by query governor.
Public property QueryWait Gets or sets the query wait.
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 or sets the connections of the user.
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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft