Export (0) Print
Expand All

Configuration Class

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

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

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

public class Configuration : ConfigurationBase

The Configuration type exposes the following members.

  NameDescription
Public propertyAdHocDistributedQueriesEnabledGets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.
Public propertyAffinity64IOMaskGets the ConfigProperty object that is used to set the affinity 64 IO mask configuration option.
Public propertyAffinity64MaskGets the ConfigProperty object that is used to set the affinity 64 mask configuration option.
Public propertyAffinityIOMaskGets the ConfigProperty object that is used to set the affinity IO mask configuration option.
Public propertyAffinityMaskGets the ConfigProperty object that is used to set the affinity mask configuration option.
Public propertyAgentXPsEnabledGets the ConfigProperty object that is used to set the agent XPs enabled configuration option.
Public propertyAllowUpdatesGets the ConfigProperty object that is used to set the allow updates configuration option.
Public propertyAweEnabled Obsolete. Gets the ConfigProperty object that is used to set the AWE enabled configuration option.
Public propertyBlockedProcessThresholdGets the ConfigProperty object that sets the blocked process threshold configuration option.
Public propertyC2AuditModeGets the ConfigProperty object that is used to set the C2 audit mode configuration option.
Public propertyCommonCriteriaComplianceEnabledGets the ConfigProperty object that is used to set the common criteria compliance enabled configuration option.
Public propertyContainmentEnabledGets the ConfigProperty object that is used to set the CONTAINMENT enabled configuration option.
Public propertyCostThresholdForParallelismGets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.
Public propertyCrossDBOwnershipChainingGets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.
Public propertyCursorThresholdGets the ConfigProperty object that is used to set the cursor threshold configuration option.
Public propertyDatabaseMailEnabledGets the ConfigProperty object that is used to set the database mail enabled configuration option.
Public propertyDefaultBackupCompressionGets the ConfigProperty object that is used to set the default backup compression configuration option.
Public propertyDefaultFullTextLanguageGets the ConfigProperty object that is used to set default full text language configuration option.
Public propertyDefaultLanguageGets the ConfigProperty object that is used to set the default language configuration option.
Public propertyDefaultTraceEnabledGets the ConfigProperty object that is used to set the default trace enabled configuration option.
Public propertyDisallowResultsFromTriggersGets the ConfigProperty object that is used to set the disallow results from triggers configuration option.
Public propertyExtensibleKeyManagementEnabledGets the ConfigProperty object that is used to set the extensible key management enabled configuration option.
Public propertyFilestreamAccessLevelGets the ConfigProperty object that sets the FILESTREAM access level configuration option.
Public propertyFillFactorGets the ConfigProperty object that is used to set the fill factor configuration option.
Public propertyFullTextCrawlBandwidthMaxGets the ConfigProperty object that is used to set the full text crawl bandwith max configuration option.
Public propertyFullTextCrawlBandwidthMinGets the ConfigProperty object that is used to set the full text crawl bandwith min configuration option.
Public propertyFullTextCrawlRangeMaxGets the ConfigProperty object that is used to set the full text crawl range max configuration option.
Public propertyFullTextNotifyBandwidthMaxGets the ConfigProperty object that is used to set the full text notify bandwith max configuration option.
Public propertyFullTextNotifyBandwidthMinGets the ConfigProperty object that is used to set the full text notify bandwith min configuration option.
Public propertyIndexCreateMemoryGets the ConfigProperty object that is used to set the index create memory configuration option.
Public propertyInDoubtTransactionResolutionGets the ConfigProperty object that is used to set the in doubt transaction resolution configuration option.
Public propertyIsSqlClrEnabledGets the ConfigProperty object that is used to set the is SQL Server CLR enabled configuration option.
Public propertyLightweightPoolingGets the ConfigProperty object that is used to set the lightweight pooling configuration option.
Public propertyLocksGets the ConfigProperty object that is used to set the locks configuration option.
Public propertyMaxDegreeOfParallelismGets the ConfigProperty object that is used to set the max degree of parallelism configuration option.
Public propertyMaxServerMemoryGets the ConfigProperty object that is used to set the max server memory configuration option.
Public propertyMaxWorkerThreadsGets the ConfigProperty object that is used to set the max worker threads configuration option.
Public propertyMediaRetentionGets the ConfigProperty object that is used to set the media retention configuration option.
Public propertyMinMemoryPerQueryGets the ConfigProperty object that is used to set the min memory per query configuration option.
Public propertyMinServerMemoryGets the ConfigProperty object that is used to set the min server memory configuration option.
Public propertyNestedTriggersGets the ConfigProperty object that is used to set the nested triggers configuration option.
Public propertyNetworkPacketSizeGets the ConfigProperty object that is used to set the network packet size configuration option.
Public propertyOleAutomationProceduresEnabledGets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.
Public propertyOpenObjectsGets the ConfigProperty object that is used to set the open objects configuration option.
Public propertyOptimizeAdhocWorkloadsGets the ConfigProperty object that sets the optimize ad hoc workloads configuration option.
Public propertyParentGets the Server object that is the parent of the Configuration object. (Inherited from ConfigurationBase.)
Public propertyPrecomputeRankGets the ConfigProperty object that is used to set the precompute rank configuration option.
Public propertyPriorityBoostGets the ConfigProperty object that is used to set the priority boost configuration option.
Public propertyPropertiesReturns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.
Public propertyProtocolHandlerTimeoutGets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.
Public propertyQueryGovernorCostLimitGets the ConfigProperty object that is used to set the query governor cost limit option.
Public propertyQueryWaitGets the ConfigProperty object that is used to set the query wait configuration option.
Public propertyRecoveryIntervalGets the ConfigProperty object that is used to set the recovery interval configuration option.
Public propertyRemoteAccessGets the ConfigProperty object that is used to set the remote access configuration option.
Public propertyRemoteDacConnectionsEnabledGets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.
Public propertyRemoteLoginTimeoutGets the ConfigProperty object that is used to set the remote login timeout configuration option.
Public propertyRemoteProcTransGets the ConfigProperty object that is used to set the remote proc trans configuration option.
Public propertyRemoteQueryTimeoutGets the ConfigProperty object that is used to set the remote query timeout configuration option.
Public propertyReplicationMaxTextSizeGets the ConfigProperty object that is used to set the replication max text size configuration option.
Public propertyReplicationXPsEnabledGets the ConfigProperty object that is used to set the replication XPs enabled configuration option.
Public propertyScanForStartupProceduresGets the ConfigProperty object that is used to set the scan for startup procedures configuration option.
Public propertyServerTriggerRecursionEnabledGets the ConfigProperty object that is used to set the server trigger recursion enabled configuration option.
Public propertySetWorkingSetSizeGets the ConfigProperty object that is used to set the set working set size configuration option.
Public propertyShowAdvancedOptionsGets the ConfigProperty object that is used to set the show advanced options configuration option.
Public propertySmoAndDmoXPsEnabledGets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.
Public propertySqlMailXPsEnabledGets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.
Public propertyTransformNoiseWordsGets the ConfigProperty object that is used to set the transform noise words configuration option.
Public propertyTwoDigitYearCutoffGets the ConfigProperty object that is used to set the two digit year cutoff configuration option.
Public propertyUserConnectionsGets the ConfigProperty object that is used to set the user connections configuration option.
Public propertyUserInstancesEnabledGets the ConfigProperty object that is used to set the user instances enabled configuration option.
Public propertyUserInstanceTimeoutGets the ConfigProperty object that is used to set the user instance timeout configuration option.
Public propertyUserOptionsGets the ConfigProperty object that is used to set the user options configuration option.
Public propertyWebXPsEnabledGets the ConfigProperty object that is used to set the web XPs enabled configuration option.
Public propertyXPCmdShellEnabledGets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option.
Top

  NameDescription
Public methodAlter()Updates the Configuration object property changes on the instance of SQL Server.  (Inherited from ConfigurationBase.)
Public methodAlter(Boolean)Updates the Configuration object property changes on the instance of SQL Server.  (Inherited from ConfigurationBase.)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRefreshRefreshes the Configuration object properties. (Inherited from ConfigurationBase.)
Public methodToString (Inherited from Object.)
Top

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.

Thread Safety

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.

Community Additions

ADD
Show:
© 2014 Microsoft