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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft