Configuration Members

  • Article

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

The following tables list the members exposed by the Configuration type.

Public Properties

  Name Description
ms219418.pubproperty(en-US,SQL.90).gif AdHocDistributedQueriesEnabled Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.
ms219418.pubproperty(en-US,SQL.90).gif Affinity64Mask Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option.
ms219418.pubproperty(en-US,SQL.90).gif AffinityIOMask Gets the ConfigProperty object that is used to set the affinity IO mask configuration option.
ms219418.pubproperty(en-US,SQL.90).gif AffinityMask Gets the ConfigProperty object that is used to set the affinity mask configuration option.
ms219418.pubproperty(en-US,SQL.90).gif AgentXPsEnabled Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif AllowUpdates Gets the ConfigProperty object that is used to set the allow updates configuration option.
ms219418.pubproperty(en-US,SQL.90).gif AweEnabled Gets the ConfigProperty object that is used to set the AWE enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif C2AuditMode Gets the ConfigProperty object that is used to set the C2 audit mode configuration option.
ms219418.pubproperty(en-US,SQL.90).gif CostThresholdForParallelism Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.
ms219418.pubproperty(en-US,SQL.90).gif CrossDBOwnershipChaining Gets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.
ms219418.pubproperty(en-US,SQL.90).gif CursorThreshold Gets the ConfigProperty object that is used to set the cursor threshold configuration option.
ms219418.pubproperty(en-US,SQL.90).gif DatabaseMailEnabled Gets the ConfigProperty object that is used to set the database mail enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif DefaultFullTextLanguage Gets the ConfigProperty object that is used to set default full text language configuration option.
ms219418.pubproperty(en-US,SQL.90).gif DefaultLanguage Gets the ConfigProperty object that is used to set the default language configuration option.
ms219418.pubproperty(en-US,SQL.90).gif FillFactor Gets the ConfigProperty object that is used to set the fill factor configuration option.
ms219418.pubproperty(en-US,SQL.90).gif IndexCreateMemory Gets the ConfigProperty object that is used to set the index create memory configuration option.
ms219418.pubproperty(en-US,SQL.90).gif IsSqlClrEnabled Gets the ConfigProperty object that is used to set the is SQL CLR enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif LightweightPooling Gets the ConfigProperty object that is used to set the lightweight pooling configuration option.
ms219418.pubproperty(en-US,SQL.90).gif Locks Gets the ConfigProperty object that is used to set the locks configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MaxDegreeOfParallelism Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MaxServerMemory Gets the ConfigProperty object that is used to set the max server memory configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MaxWorkerThreads Gets the ConfigProperty object that is used to set the max worker threads configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MediaRetention Gets the ConfigProperty object that is used to set the media retention configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MinMemoryPerQuery Gets the ConfigProperty object that is used to set the min memory per query configuration option.
ms219418.pubproperty(en-US,SQL.90).gif MinServerMemory Gets the ConfigProperty object that is used to set the min server memory configuration option.
ms219418.pubproperty(en-US,SQL.90).gif NestedTriggers Gets the ConfigProperty object that is used to set the nested triggers configuration option.
ms219418.pubproperty(en-US,SQL.90).gif NetworkPacketSize Gets the ConfigProperty object that is used to set the network packet size configuration option.
ms219418.pubproperty(en-US,SQL.90).gif OleAutomationProceduresEnabled Gets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif OpenObjects Gets the ConfigProperty object that is used to set the open objects configuration option.
ms219418.pubproperty(en-US,SQL.90).gif Parent  Gets the Server object that is the parent of the Configuration object. (inherited from ConfigurationBase)
ms219418.pubproperty(en-US,SQL.90).gif PrecomputeRank Gets the ConfigProperty object that is used to set the precompute rank configuration option.
ms219418.pubproperty(en-US,SQL.90).gif PriorityBoost Gets the ConfigProperty object that is used to set the priority boost configuration option.
ms219418.pubproperty(en-US,SQL.90).gif Properties Returns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.
ms219418.pubproperty(en-US,SQL.90).gif ProtocolHandlerTimeout Gets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.
ms219418.pubproperty(en-US,SQL.90).gif QueryGovernorCostLimit Gets the ConfigProperty object that is used to set the query governor cost limit option.
ms219418.pubproperty(en-US,SQL.90).gif QueryWait Gets the ConfigProperty object that is used to set the query wait configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RecoveryInterval Gets the ConfigProperty object that is used to set the recovery interval configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RemoteAccess Gets the ConfigProperty object that is used to set the remote access configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RemoteDacConnectionsEnabled Gets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RemoteLoginTimeout Gets the ConfigProperty object that is used to set the remote login timeout configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RemoteProcTrans Gets the ConfigProperty object that is used to set the remote proc trans configuration option.
ms219418.pubproperty(en-US,SQL.90).gif RemoteQueryTimeout Gets the ConfigProperty object that is used to set the remote query timeout configuration option.
ms219418.pubproperty(en-US,SQL.90).gif ReplicationMaxTextSize Gets the ConfigProperty object that is used to set the replication max text size configuration option.
ms219418.pubproperty(en-US,SQL.90).gif ReplicationXPsEnabled Gets the ConfigProperty object that is used to set the replication XPs enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif ScanForStartupProcedures Gets the ConfigProperty object that is used to set the scan for startup procedures configuration option.
ms219418.pubproperty(en-US,SQL.90).gif SetWorkingSetSize Gets the ConfigProperty object that is used to set the set working set size configuration option.
ms219418.pubproperty(en-US,SQL.90).gif ShowAdvancedOptions Gets the ConfigProperty object that is used to set the show advanced options configuration option.
ms219418.pubproperty(en-US,SQL.90).gif SmoAndDmoXPsEnabled Gets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif SqlMailXPsEnabled Gets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif TransformNoiseWords Gets the ConfigProperty object that is used to set the transform noise words configuration option.
ms219418.pubproperty(en-US,SQL.90).gif TwoDigitYearCutoff Gets the ConfigProperty object that is used to set the two digit year cutoff configuration option.
ms219418.pubproperty(en-US,SQL.90).gif UserConnections Gets the ConfigProperty object that is used to set the user connections configuration option.
ms219418.pubproperty(en-US,SQL.90).gif UserOptions Gets the ConfigProperty object that is used to set the user options configuration option.
ms219418.pubproperty(en-US,SQL.90).gif WebXPsEnabled Gets the ConfigProperty object that is used to set the web XPs enabled configuration option.
ms219418.pubproperty(en-US,SQL.90).gif XPCmdShellEnabled Gets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219418.pubmethod(en-US,SQL.90).gif Alter  Overloaded. Updates the Configuration object property changes on the instance of Microsoft SQL Server. (inherited from ConfigurationBase)
ms219418.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219418.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219418.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219418.pubmethod(en-US,SQL.90).gifms219418.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219418.pubmethod(en-US,SQL.90).gif Refresh  Refreshes the Configuration object properties. (inherited from ConfigurationBase)
ms219418.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms219418.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219418.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

Configuration Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Configuring SQL Server in SMO
Setting Server Configuration Options
sp_configure (Transact-SQL)