Export (0) Print
Expand All

Configuration Class

 

Applies To: SQL Server 2016 Preview

Represents the Configuration class that contains the configuration information for the instance of SQL Server.

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

System.Object
  Microsoft.SqlServer.Management.Smo.ConfigurationBase
    Microsoft.SqlServer.Management.Smo.Configuration

Public Class Configuration
	Inherits ConfigurationBase

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.

NameDescription
System_CAPS_pubmethodAlter()

Updates the Configuration object property changes on the instance of SQL Server. (Inherited from ConfigurationBase.)

System_CAPS_pubmethodAlter(Boolean)

Updates the Configuration object property changes on the instance of SQL Server. (Inherited from ConfigurationBase.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodRefresh()

Refreshes the Configuration object properties.(Inherited from ConfigurationBase.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

Modifying the Configuration object is equivalent to using the Transact-SQL sp_configure statement.

To get Configuration object properties, users can be a member of the public fixed server role.

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft