Share via


Configuration Class

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

Inheritance Hierarchy

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)

Syntax

'Declaration
Public Class Configuration _
    Inherits ConfigurationBase
'Usage
Dim instance As Configuration
public class Configuration : ConfigurationBase
public ref class Configuration : public ConfigurationBase
type Configuration =  
    class
        inherit ConfigurationBase
    end
public class Configuration extends ConfigurationBase

The Configuration type exposes the following members.

Properties

  Name Description
Public property AdHocDistributedQueriesEnabled Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.
Public property Affinity64IOMask Gets the ConfigProperty object that is used to set the affinity 64 IO mask configuration option.
Public property Affinity64Mask Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option.
Public property AffinityIOMask Gets the ConfigProperty object that is used to set the affinity IO mask configuration option.
Public property AffinityMask Gets the ConfigProperty object that is used to set the affinity mask configuration option.
Public property AgentXPsEnabled Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option.
Public property AllowUpdates Gets the ConfigProperty object that is used to set the allow updates configuration option.
Public property AweEnabled Gets the ConfigProperty object that is used to set the AWE enabled configuration option.
Public property BlockedProcessThreshold Gets the ConfigProperty object that sets the blocked process threshold configuration option.
Public property C2AuditMode Gets the ConfigProperty object that is used to set the C2 audit mode configuration option.
Public property CommonCriteriaComplianceEnabled Gets the ConfigProperty object that is used to set the common criteria compliance enabled configuration option.
Public property CostThresholdForParallelism Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.
Public property CrossDBOwnershipChaining Gets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.
Public property CursorThreshold Gets the ConfigProperty object that is used to set the cursor threshold configuration option.
Public property DatabaseMailEnabled Gets the ConfigProperty object that is used to set the database mail enabled configuration option.
Public property DefaultBackupCompression Gets the ConfigProperty object that is used to set the default backup compression configuration option.
Public property DefaultFullTextLanguage Gets the ConfigProperty object that is used to set default full text language configuration option.
Public property DefaultLanguage Gets the ConfigProperty object that is used to set the default language configuration option.
Public property DefaultTraceEnabled Gets the ConfigProperty object that is used to set the default trace enabled configuration option.
Public property DisallowResultsFromTriggers Gets the ConfigProperty object that is used to set the disallow results from triggers configuration option.
Public property ExtensibleKeyManagementEnabled Gets the ConfigProperty object that is used to set the extensible key management enabled configuration option.
Public property FilestreamAccessLevel Gets the ConfigProperty object that sets the FILESTREAM access level configuration option.
Public property FillFactor Gets the ConfigProperty object that is used to set the fill factor configuration option.
Public property FullTextCrawlBandwidthMax Gets the ConfigProperty object that is used to set the full text crawl bandwith max configuration option.
Public property FullTextCrawlBandwidthMin Gets the ConfigProperty object that is used to set the full text crawl bandwith min configuration option.
Public property FullTextCrawlRangeMax Gets the ConfigProperty object that is used to set the full text crawl range max configuration option.
Public property FullTextNotifyBandwidthMax Gets the ConfigProperty object that is used to set the full text notify bandwith max configuration option.
Public property FullTextNotifyBandwidthMin Gets the ConfigProperty object that is used to set the full text notify bandwith min configuration option.
Public property IndexCreateMemory Gets the ConfigProperty object that is used to set the index create memory configuration option.
Public property InDoubtTransactionResolution Gets the ConfigProperty object that is used to set the in doubt transaction resolution configuration option.
Public property IsSqlClrEnabled Gets the ConfigProperty object that is used to set the CLR enabled configuration option.
Public property LightweightPooling Gets the ConfigProperty object that is used to set the lightweight pooling configuration option.
Public property Locks Gets the ConfigProperty object that is used to set the locks configuration option.
Public property MaxDegreeOfParallelism Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option.
Public property MaxServerMemory Gets the ConfigProperty object that is used to set the max server memory configuration option.
Public property MaxWorkerThreads Gets the ConfigProperty object that is used to set the max worker threads configuration option.
Public property MediaRetention Gets the ConfigProperty object that is used to set the media retention configuration option.
Public property MinMemoryPerQuery Gets the ConfigProperty object that is used to set the min memory per query configuration option.
Public property MinServerMemory Gets the ConfigProperty object that is used to set the min server memory configuration option.
Public property NestedTriggers Gets the ConfigProperty object that is used to set the nested triggers configuration option.
Public property NetworkPacketSize Gets the ConfigProperty object that is used to set the network packet size configuration option.
Public property OleAutomationProceduresEnabled Gets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.
Public property OpenObjects Gets the ConfigProperty object that is used to set the open objects configuration option.
Public property OptimizeAdhocWorkloads Gets the ConfigProperty object that sets the optimize ad hoc workloads configuration option.
Public property Parent Gets the Server object that is the parent of the Configuration object. (Inherited from ConfigurationBase.)
Public property PrecomputeRank Gets the ConfigProperty object that is used to set the precompute rank configuration option.
Public property PriorityBoost Gets the ConfigProperty object that is used to set the priority boost configuration option.
Public property Properties Returns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.
Public property ProtocolHandlerTimeout Gets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.
Public property QueryGovernorCostLimit Gets the ConfigProperty object that is used to set the query governor cost limit option.
Public property QueryWait Gets the ConfigProperty object that is used to set the query wait configuration option.
Public property RecoveryInterval Gets the ConfigProperty object that is used to set the recovery interval configuration option.
Public property RemoteAccess Gets the ConfigProperty object that is used to set the remote access configuration option.
Public property RemoteDacConnectionsEnabled Gets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.
Public property RemoteLoginTimeout Gets the ConfigProperty object that is used to set the remote login timeout configuration option.
Public property RemoteProcTrans Gets the ConfigProperty object that is used to set the remote proc trans configuration option.
Public property RemoteQueryTimeout Gets the ConfigProperty object that is used to set the remote query timeout configuration option.
Public property ReplicationMaxTextSize Gets the ConfigProperty object that is used to set the replication max text size configuration option.
Public property ReplicationXPsEnabled Gets the ConfigProperty object that is used to set the replication XPs enabled configuration option.
Public property ScanForStartupProcedures Gets the ConfigProperty object that is used to set the scan for startup procedures configuration option.
Public property ServerTriggerRecursionEnabled Gets the ConfigProperty object that is used to set the server trigger recursion enabled configuration option.
Public property SetWorkingSetSize Gets the ConfigProperty object that is used to set the set working set size configuration option.
Public property ShowAdvancedOptions Gets the ConfigProperty object that is used to set the show advanced options configuration option.
Public property SmoAndDmoXPsEnabled Gets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.
Public property SqlMailXPsEnabled Gets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.
Public property TransformNoiseWords Gets the ConfigProperty object that is used to set the transform noise words configuration option.
Public property TwoDigitYearCutoff Gets the ConfigProperty object that is used to set the two digit year cutoff configuration option.
Public property UserConnections Gets the ConfigProperty object that is used to set the user connections configuration option.
Public property UserInstancesEnabled Gets the ConfigProperty object that is used to set the user instances enabled configuration option.
Public property UserInstanceTimeout Gets the ConfigProperty object that is used to set the user instance timeout configuration option.
Public property UserOptions Gets the ConfigProperty object that is used to set the user options configuration option.
Public property WebXPsEnabled Gets the ConfigProperty object that is used to set the web XPs enabled configuration option.
Public property XPCmdShellEnabled Gets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option.

Top

Methods

  Name Description
Public method Alter() Updates the Configuration object property changes on the instance of SQL Server.  (Inherited from ConfigurationBase.)
Public method Alter(Boolean) Updates the Configuration object property changes on the instance of SQL Server.  (Inherited from ConfigurationBase.)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Refresh Refreshes the Configuration object properties. (Inherited from ConfigurationBase.)
Public method ToString (Inherited from Object.)

Top

Remarks

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.

Thread Safety

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