Configuration Configuration Configuration Class

Definition

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

public ref class Configuration : Microsoft::SqlServer::Management::Smo::ConfigurationBase
public class Configuration : Microsoft.SqlServer.Management.Smo.ConfigurationBase
Public Class Configuration
Inherits ConfigurationBase
Inheritance

Examples

Configuring SQL Server in SMO

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.

Properties

AdHocDistributedQueriesEnabled AdHocDistributedQueriesEnabled AdHocDistributedQueriesEnabled

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

Affinity64IOMask Affinity64IOMask Affinity64IOMask

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

Affinity64Mask Affinity64Mask Affinity64Mask

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

AffinityIOMask AffinityIOMask AffinityIOMask

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

AffinityMask AffinityMask AffinityMask

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

AgentXPsEnabled AgentXPsEnabled AgentXPsEnabled

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

AllowUpdates AllowUpdates AllowUpdates

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

AweEnabled AweEnabled AweEnabled

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

BlockedProcessThreshold BlockedProcessThreshold BlockedProcessThreshold

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

C2AuditMode C2AuditMode C2AuditMode

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

CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled

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

ContainmentEnabled ContainmentEnabled ContainmentEnabled

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

CostThresholdForParallelism CostThresholdForParallelism CostThresholdForParallelism

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

CrossDBOwnershipChaining CrossDBOwnershipChaining CrossDBOwnershipChaining

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

CursorThreshold CursorThreshold CursorThreshold

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

DatabaseMailEnabled DatabaseMailEnabled DatabaseMailEnabled

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

DefaultBackupCompression DefaultBackupCompression DefaultBackupCompression

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

DefaultFullTextLanguage DefaultFullTextLanguage DefaultFullTextLanguage

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

DefaultLanguage DefaultLanguage DefaultLanguage

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

DefaultTraceEnabled DefaultTraceEnabled DefaultTraceEnabled

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

DisallowResultsFromTriggers DisallowResultsFromTriggers DisallowResultsFromTriggers

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

ExtensibleKeyManagementEnabled ExtensibleKeyManagementEnabled ExtensibleKeyManagementEnabled

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

FilestreamAccessLevel FilestreamAccessLevel FilestreamAccessLevel

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

FillFactor FillFactor FillFactor

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

FullTextCrawlBandwidthMax FullTextCrawlBandwidthMax FullTextCrawlBandwidthMax

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

FullTextCrawlBandwidthMin FullTextCrawlBandwidthMin FullTextCrawlBandwidthMin

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

FullTextCrawlRangeMax FullTextCrawlRangeMax FullTextCrawlRangeMax

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

FullTextNotifyBandwidthMax FullTextNotifyBandwidthMax FullTextNotifyBandwidthMax

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

FullTextNotifyBandwidthMin FullTextNotifyBandwidthMin FullTextNotifyBandwidthMin

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

IndexCreateMemory IndexCreateMemory IndexCreateMemory

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

InDoubtTransactionResolution InDoubtTransactionResolution InDoubtTransactionResolution

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

IsSqlClrEnabled IsSqlClrEnabled IsSqlClrEnabled

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

LightweightPooling LightweightPooling LightweightPooling

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

Locks Locks Locks

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

MaxDegreeOfParallelism MaxDegreeOfParallelism MaxDegreeOfParallelism

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

MaxServerMemory MaxServerMemory MaxServerMemory

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

MaxWorkerThreads MaxWorkerThreads MaxWorkerThreads

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

MediaRetention MediaRetention MediaRetention

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

MinMemoryPerQuery MinMemoryPerQuery MinMemoryPerQuery

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

MinServerMemory MinServerMemory MinServerMemory

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

NestedTriggers NestedTriggers NestedTriggers

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

NetworkPacketSize NetworkPacketSize NetworkPacketSize

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

OleAutomationProceduresEnabled OleAutomationProceduresEnabled OleAutomationProceduresEnabled

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

OpenObjects OpenObjects OpenObjects

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

OptimizeAdhocWorkloads OptimizeAdhocWorkloads OptimizeAdhocWorkloads

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

Parent Parent Parent

Gets the Server object that is the parent of the Configuration object.

(Inherited from ConfigurationBase)
PrecomputeRank PrecomputeRank PrecomputeRank

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

PriorityBoost PriorityBoost PriorityBoost

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

Properties Properties Properties

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

ProtocolHandlerTimeout ProtocolHandlerTimeout ProtocolHandlerTimeout

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

QueryGovernorCostLimit QueryGovernorCostLimit QueryGovernorCostLimit

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

QueryWait QueryWait QueryWait

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

RecoveryInterval RecoveryInterval RecoveryInterval

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

RemoteAccess RemoteAccess RemoteAccess

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

RemoteDacConnectionsEnabled RemoteDacConnectionsEnabled RemoteDacConnectionsEnabled

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

RemoteDataArchiveEnabled RemoteDataArchiveEnabled RemoteDataArchiveEnabled

Gets a value that indicates whether the remote data archive is enabled.

RemoteLoginTimeout RemoteLoginTimeout RemoteLoginTimeout

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

RemoteProcTrans RemoteProcTrans RemoteProcTrans

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

RemoteQueryTimeout RemoteQueryTimeout RemoteQueryTimeout

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

ReplicationMaxTextSize ReplicationMaxTextSize ReplicationMaxTextSize

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

ReplicationXPsEnabled ReplicationXPsEnabled ReplicationXPsEnabled

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

ScanForStartupProcedures ScanForStartupProcedures ScanForStartupProcedures

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

ServerTriggerRecursionEnabled ServerTriggerRecursionEnabled ServerTriggerRecursionEnabled

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

SetWorkingSetSize SetWorkingSetSize SetWorkingSetSize

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

ShowAdvancedOptions ShowAdvancedOptions ShowAdvancedOptions

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

SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled

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

SqlMailXPsEnabled SqlMailXPsEnabled SqlMailXPsEnabled

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

TransformNoiseWords TransformNoiseWords TransformNoiseWords

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

TwoDigitYearCutoff TwoDigitYearCutoff TwoDigitYearCutoff

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

UserConnections UserConnections UserConnections

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

UserInstancesEnabled UserInstancesEnabled UserInstancesEnabled

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

UserInstanceTimeout UserInstanceTimeout UserInstanceTimeout

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

UserOptions UserOptions UserOptions

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

WebXPsEnabled WebXPsEnabled WebXPsEnabled

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

XPCmdShellEnabled XPCmdShellEnabled XPCmdShellEnabled

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

Methods

Alter() Alter() Alter()

Updates the Configuration object property changes on the instance of SQL Server.

(Inherited from ConfigurationBase)
Alter(Boolean) Alter(Boolean) Alter(Boolean)

Updates the Configuration object property changes on the instance of SQL Server.

(Inherited from ConfigurationBase)
Refresh() Refresh() Refresh()

Refreshes the Configuration object properties.

(Inherited from ConfigurationBase)

Applies to