Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

Configuration Properties

 

Applies To: SQL Server 2016 Preview

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

NameDescription
System_CAPS_pubpropertyAdHocDistributedQueriesEnabled

Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.

System_CAPS_pubpropertyAffinity64IOMask

Gets the ConfigProperty object that is used to set the affinity 64 IO mask configuration option.

System_CAPS_pubpropertyAffinity64Mask

Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option.

System_CAPS_pubpropertyAffinityIOMask

Gets the ConfigProperty object that is used to set the affinity IO mask configuration option.

System_CAPS_pubpropertyAffinityMask

Gets the ConfigProperty object that is used to set the affinity mask configuration option.

System_CAPS_pubpropertyAgentXPsEnabled

Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option.

System_CAPS_pubpropertyAllowUpdates

Gets the ConfigProperty object that is used to set the allow updates configuration option.

System_CAPS_pubpropertyAweEnabled

Obsolete.Gets the ConfigProperty object that is used to set the AWE enabled configuration option.

System_CAPS_pubpropertyBlockedProcessThreshold

Gets the ConfigProperty object that sets the blocked process threshold configuration option.

System_CAPS_pubpropertyC2AuditMode

Gets the ConfigProperty object that is used to set the C2 audit mode configuration option.

System_CAPS_pubpropertyCommonCriteriaComplianceEnabled

Gets the ConfigProperty object that is used to set the common criteria compliance enabled configuration option.

System_CAPS_pubpropertyContainmentEnabled

Gets the ConfigProperty object that is used to set the CONTAINMENT enabled configuration option.

System_CAPS_pubpropertyCostThresholdForParallelism

Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.

System_CAPS_pubpropertyCrossDBOwnershipChaining

Gets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.

System_CAPS_pubpropertyCursorThreshold

Gets the ConfigProperty object that is used to set the cursor threshold configuration option.

System_CAPS_pubpropertyDatabaseMailEnabled

Gets the ConfigProperty object that is used to set the database mail enabled configuration option.

System_CAPS_pubpropertyDefaultBackupCompression

Gets the ConfigProperty object that is used to set the default backup compression configuration option.

System_CAPS_pubpropertyDefaultFullTextLanguage

Gets the ConfigProperty object that is used to set default full text language configuration option.

System_CAPS_pubpropertyDefaultLanguage

Gets the ConfigProperty object that is used to set the default language configuration option.

System_CAPS_pubpropertyDefaultTraceEnabled

Gets the ConfigProperty object that is used to set the default trace enabled configuration option.

System_CAPS_pubpropertyDisallowResultsFromTriggers

Gets the ConfigProperty object that is used to set the disallow results from triggers configuration option.

System_CAPS_pubpropertyExtensibleKeyManagementEnabled

Gets the ConfigProperty object that is used to set the extensible key management enabled configuration option.

System_CAPS_pubpropertyFilestreamAccessLevel

Gets the ConfigProperty object that sets the FILESTREAM access level configuration option.

System_CAPS_pubpropertyFillFactor

Gets the ConfigProperty object that is used to set the fill factor configuration option.

System_CAPS_pubpropertyFullTextCrawlBandwidthMax

Gets the ConfigProperty object that is used to set the full text crawl bandwith max configuration option.

System_CAPS_pubpropertyFullTextCrawlBandwidthMin

Gets the ConfigProperty object that is used to set the full text crawl bandwith min configuration option.

System_CAPS_pubpropertyFullTextCrawlRangeMax

Gets the ConfigProperty object that is used to set the full text crawl range max configuration option.

System_CAPS_pubpropertyFullTextNotifyBandwidthMax

Gets the ConfigProperty object that is used to set the full text notify bandwith max configuration option.

System_CAPS_pubpropertyFullTextNotifyBandwidthMin

Gets the ConfigProperty object that is used to set the full text notify bandwith min configuration option.

System_CAPS_pubpropertyIndexCreateMemory

Gets the ConfigProperty object that is used to set the index create memory configuration option.

System_CAPS_pubpropertyInDoubtTransactionResolution

Gets the ConfigProperty object that is used to set the in doubt transaction resolution configuration option.

System_CAPS_pubpropertyIsSqlClrEnabled

Gets the ConfigProperty object that is used to set the is SQL Server CLR enabled configuration option.

System_CAPS_pubpropertyLightweightPooling

Gets the ConfigProperty object that is used to set the lightweight pooling configuration option.

System_CAPS_pubpropertyLocks

Gets the ConfigProperty object that is used to set the locks configuration option.

System_CAPS_pubpropertyMaxDegreeOfParallelism

Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option.

System_CAPS_pubpropertyMaxServerMemory

Gets the ConfigProperty object that is used to set the max server memory configuration option.

System_CAPS_pubpropertyMaxWorkerThreads

Gets the ConfigProperty object that is used to set the max worker threads configuration option.

System_CAPS_pubpropertyMediaRetention

Gets the ConfigProperty object that is used to set the media retention configuration option.

System_CAPS_pubpropertyMinMemoryPerQuery

Gets the ConfigProperty object that is used to set the min memory per query configuration option.

System_CAPS_pubpropertyMinServerMemory

Gets the ConfigProperty object that is used to set the min server memory configuration option.

System_CAPS_pubpropertyNestedTriggers

Gets the ConfigProperty object that is used to set the nested triggers configuration option.

System_CAPS_pubpropertyNetworkPacketSize

Gets the ConfigProperty object that is used to set the network packet size configuration option.

System_CAPS_pubpropertyOleAutomationProceduresEnabled

Gets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.

System_CAPS_pubpropertyOpenObjects

Gets the ConfigProperty object that is used to set the open objects configuration option.

System_CAPS_pubpropertyOptimizeAdhocWorkloads

Gets the ConfigProperty object that sets the optimize ad hoc workloads configuration option.

System_CAPS_pubpropertyParent

Gets the Server object that is the parent of the Configuration object.(Inherited from ConfigurationBase.)

System_CAPS_pubpropertyPrecomputeRank

Gets the ConfigProperty object that is used to set the precompute rank configuration option.

System_CAPS_pubpropertyPriorityBoost

Gets the ConfigProperty object that is used to set the priority boost configuration option.

System_CAPS_pubpropertyProperties

Returns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.

System_CAPS_pubpropertyProtocolHandlerTimeout

Gets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.

System_CAPS_pubpropertyQueryGovernorCostLimit

Gets the ConfigProperty object that is used to set the query governor cost limit option.

System_CAPS_pubpropertyQueryWait

Gets the ConfigProperty object that is used to set the query wait configuration option.

System_CAPS_pubpropertyRecoveryInterval

Gets the ConfigProperty object that is used to set the recovery interval configuration option.

System_CAPS_pubpropertyRemoteAccess

Gets the ConfigProperty object that is used to set the remote access configuration option.

System_CAPS_pubpropertyRemoteDacConnectionsEnabled

Gets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.

System_CAPS_pubpropertyRemoteLoginTimeout

Gets the ConfigProperty object that is used to set the remote login timeout configuration option.

System_CAPS_pubpropertyRemoteProcTrans

Gets the ConfigProperty object that is used to set the remote proc trans configuration option.

System_CAPS_pubpropertyRemoteQueryTimeout

Gets the ConfigProperty object that is used to set the remote query timeout configuration option.

System_CAPS_pubpropertyReplicationMaxTextSize

Gets the ConfigProperty object that is used to set the replication max text size configuration option.

System_CAPS_pubpropertyReplicationXPsEnabled

Gets the ConfigProperty object that is used to set the replication XPs enabled configuration option.

System_CAPS_pubpropertyScanForStartupProcedures

Gets the ConfigProperty object that is used to set the scan for startup procedures configuration option.

System_CAPS_pubpropertyServerTriggerRecursionEnabled

Gets the ConfigProperty object that is used to set the server trigger recursion enabled configuration option.

System_CAPS_pubpropertySetWorkingSetSize

Gets the ConfigProperty object that is used to set the set working set size configuration option.

System_CAPS_pubpropertyShowAdvancedOptions

Gets the ConfigProperty object that is used to set the show advanced options configuration option.

System_CAPS_pubpropertySmoAndDmoXPsEnabled

Gets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.

System_CAPS_pubpropertySqlMailXPsEnabled

Gets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.

System_CAPS_pubpropertyTransformNoiseWords

Gets the ConfigProperty object that is used to set the transform noise words configuration option.

System_CAPS_pubpropertyTwoDigitYearCutoff

Gets the ConfigProperty object that is used to set the two digit year cutoff configuration option.

System_CAPS_pubpropertyUserConnections

Gets the ConfigProperty object that is used to set the user connections configuration option.

System_CAPS_pubpropertyUserInstancesEnabled

Gets the ConfigProperty object that is used to set the user instances enabled configuration option.

System_CAPS_pubpropertyUserInstanceTimeout

Gets the ConfigProperty object that is used to set the user instance timeout configuration option.

System_CAPS_pubpropertyUserOptions

Gets the ConfigProperty object that is used to set the user options configuration option.

System_CAPS_pubpropertyWebXPsEnabled

Gets the ConfigProperty object that is used to set the web XPs enabled configuration option.

System_CAPS_pubpropertyXPCmdShellEnabled

Gets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option.

Return to top
Show:
© 2015 Microsoft