Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IServerConfigurationFacet Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAdHocRemoteQueriesEnabled

Gets or sets a Boolean value that specifies whether ad hoc remote queries are enabled.

System_CAPS_pubpropertyAffinity64IOMask

Gets the affinity64 IO mask for a server.

System_CAPS_pubpropertyAffinity64Mask

Gets or sets the affinity 64 mask for a server.

System_CAPS_pubpropertyAffinityIOMask

Gets the affinity IO mask for a server.

System_CAPS_pubpropertyAffinityMask

Gets the affinity mask for a server.

System_CAPS_pubpropertyAgentXPsEnabled

Gets or sets a Boolean value that specifies whether the SQL Server Agent extended stored procedures are enabled.

System_CAPS_pubpropertyAllowUpdates

Gets or sets a Boolean value that specifies whether the allow updates option is set.

System_CAPS_pubpropertyAweEnabled

Gets a Boolean value that specifies if the awe enabled value is set.

System_CAPS_pubpropertyBlockedProcessThreshold

Gets or sets the blocked process threshold.

System_CAPS_pubpropertyC2AuditTracingEnabled

Gets a Boolean value that specifies if the C2 audit tracing is set.

System_CAPS_pubpropertyClrIntegrationEnabled

Gets or sets a Boolean value that specifies if the CLR integration value is set.

System_CAPS_pubpropertyCommonCriteriaComplianceEnabled

Gets a Boolean value that specifies if the common criteria compliance value is set.

System_CAPS_pubpropertyContainmentEnabled

Gets the value that indicates whether the containment is enabled.

System_CAPS_pubpropertyCostThresholdForParallelism

Gets or sets the value contained in the cost threshold for parallelism property.

System_CAPS_pubpropertyCrossDBOwnershipChainingEnabled

Gets or sets a Boolean value that specifies if the cross DBOwnership chaining value is set.

System_CAPS_pubpropertyCursorThreshold

Gets or sets the cursor threshold value.

System_CAPS_pubpropertyDatabaseMailEnabled

Gets a Boolean value that specifies if the DatabaseMailEnabled property is set.

System_CAPS_pubpropertyDefaultBackupCompressionEnabled

Gets or sets a Boolean value that specifies if the BackupCompressionEnabled option is set.

System_CAPS_pubpropertyDefaultFullTextLanguage

Gets or sets the DefaultFullTextLanguage property.

System_CAPS_pubpropertyDefaultLanguage

Gets or sets the DefaultLanguage property.

System_CAPS_pubpropertyDefaultTraceEnabled

Gets or sets a Boolean value that specifies if the DefaultTraceEnabled property is set.

System_CAPS_pubpropertyDisallowResultsFromTriggers

Gets or sets a Boolean value that specifies if the DisallowResultsFromTriggers property is set.

System_CAPS_pubpropertyDynamicLocks

Gets the value of the DynamicLocks property.

System_CAPS_pubpropertyExtensibleKeyManagementEnabled

Gets a Boolean value that specifies if the ExtensibleKeyManagementEnabled property is set.

System_CAPS_pubpropertyFilestreamAccessLevel

Gets or sets the level of access permitted on the servers FILESTREAM operations.

System_CAPS_pubpropertyFillFactor

Gets the value of the FillFactor property.

System_CAPS_pubpropertyFullTextCrawlBandwidthMax

Gets or sets the maximum value of the full text crawl bandwidth.

System_CAPS_pubpropertyFullTextCrawlBandwidthMin

Gets or sets the minimum value of the full text crawl bandwidth.

System_CAPS_pubpropertyFullTextCrawlRangeMax

Gets or sets the maximum value of the full text crawl range.

System_CAPS_pubpropertyFullTextNotifyBandwidthMax

Gets or sets the maximum value of the full text notify bandwidth.

System_CAPS_pubpropertyFullTextNotifyBandwidthMin

Gets or sets the FullTextNotifyBandwidthMin property value.

System_CAPS_pubpropertyIndexCreateMemory

Gets or sets the IndexCreateMemory property value.

System_CAPS_pubpropertyInDoubtTransactionResolution

Gets or sets the InDoubtTransactionResolutionType property value.

System_CAPS_pubpropertyLightweightPoolingEnabled

Gets a Boolean value that specifies if the LightweightPoolingEnabled property value is set.

System_CAPS_pubpropertyMaxDegreeOfParallelism

Gets or sets the MaxDegreeOfParallelism property value.

System_CAPS_pubpropertyMaxServerMemory

Gets or sets the MaxServerMemory property value.

System_CAPS_pubpropertyMaxWorkerThreads

Gets the MaxWorkerThreads property value.

System_CAPS_pubpropertyMediaRetention

Gets or sets the media retention.

System_CAPS_pubpropertyMinMemoryPerQuery

Gets or set the MinMemoryPerQuery property value.

System_CAPS_pubpropertyMinServerMemory

Gets or sets the MinServerMemory property value.

System_CAPS_pubpropertyNestedTriggersEnabled

Gets or sets a Boolean value that specifies if the NestedTriggersEnabled property value is set.

System_CAPS_pubpropertyNetworkPacketSize

Gets or sets the NetworkPacketSize property value.

System_CAPS_pubpropertyOleAutomationEnabled

Gets or sets a Boolean value that specifies if the OleAutomationEnabled property value is set.

System_CAPS_pubpropertyOpenObjects

Gets the OpenObjects property value.

System_CAPS_pubpropertyOptimizeAdhocWorkloads

Gets or sets a value that determines whether ad hoc workloads will be optimized.

System_CAPS_pubpropertyPrecomputeRank

Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set.

System_CAPS_pubpropertyPriorityBoost

Gets a Boolean value that specifies if the PriorityBoost property value is set.

System_CAPS_pubpropertyProtocolHandlerTimeout

Gets or sets the ProtocolHandlerTimeout property value.

System_CAPS_pubpropertyQueryGovernorCostLimit

Gets or sets the maximum estimated cost allowed by query governor.

System_CAPS_pubpropertyQueryWait

Gets or sets the query wait.

System_CAPS_pubpropertyRecoveryInterval

Gets or sets the RecoveryInterval property value.

System_CAPS_pubpropertyRemoteAccessEnabled

Gets a Boolean value that specifies if the RemoteAccessEnabled property has been set.

System_CAPS_pubpropertyRemoteDacEnabled

Gets or sets a Boolean value that specifies if the RemoteDacEnabled property is set.

System_CAPS_pubpropertyRemoteLoginTimeout

Gets or sets the RemoteLoginTimeout property value.

System_CAPS_pubpropertyRemoteProcTransEnabled

Gets or sets a Boolean value that specifies if the RemoteProcTransEnabled is set.

System_CAPS_pubpropertyRemoteQueryTimeout

Gets or sets the RemoteQueryTimeout property value.

System_CAPS_pubpropertyReplicationMaxTextSize

Gets or sets the ReplicationMaxTextSize property value.

System_CAPS_pubpropertyReplicationXPsEnabled

Gets or sets a Boolean value that specifies if the ReplicationXPsEnabled property is set.

System_CAPS_pubpropertyScanForStartupProcedures

Gets or sets a Boolean value that specifies if the ScanForStartupProcedures property is set.

System_CAPS_pubpropertyServerTriggerRecursionEnabled

Gets or sets a Boolean value that specifies if the ServerTriggerRecursionEnabled property is set.

System_CAPS_pubpropertySetWorkingSetSize

Gets a Boolean value that specifies if the SetWorkingSetSize property value is set.

System_CAPS_pubpropertyShowAdvancedOptions

Gets or sets a Boolean value that specifies if the ShowAdvancedOptions property value is set.

System_CAPS_pubpropertySmoAndDmoXPsEnabled

Gets or sets a Boolean value that specifies if the SmoAndDmoSPsEnabled property value is set.

System_CAPS_pubpropertySqlMailEnabled

Gets or sets a Boolean value that specifies if the SqlMailEnabled property value is set.

System_CAPS_pubpropertyTransformNoiseWords

Gets or sets a Boolean value that specifies if the TransformNoiseWords property value is set.

System_CAPS_pubpropertyTwoDigitYearCutoff

Gets or sets the TwoDigitYearCutoff property value.

System_CAPS_pubpropertyUserConnections

Gets or sets the connections of the user.

System_CAPS_pubpropertyUserInstancesEnabled

Gets or sets a Boolean value that specifies if the UserInstancesEnabled property value is set.

System_CAPS_pubpropertyUserInstanceTimeout

Gets or sets the UserInstanceTimeout property value.

System_CAPS_pubpropertyUserOptions

Gets or sets the UserOptions property value.

System_CAPS_pubpropertyWebAssistantEnabled

Gets or sets a Boolean value that specifies if the WebAssistantEnabled property value is set

System_CAPS_pubpropertyXPCmdShellEnabled

Gets or sets a Boolean value that specifies if the XPCmdShellEnabled property is set.

Return to top
Show:
© 2015 Microsoft