Configuration 类

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

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public Class Configuration _
    Inherits ConfigurationBase
用法
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

Configuration 类型公开以下成员。

属性

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

页首

方法

  名称 说明
公共方法 Alter() Updates the Configuration object property changes on the instance of SQL Server.  (从 ConfigurationBase 继承。)
公共方法 Alter(Boolean) Updates the Configuration object property changes on the instance of SQL Server.  (从 ConfigurationBase 继承。)
公共方法 Equals (从 Object 继承。)
受保护方法 Finalize (从 Object 继承。)
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetType (从 Object 继承。)
受保护方法 MemberwiseClone (从 Object 继承。)
公共方法 Refresh Refreshes the Configuration object properties. (从 ConfigurationBase 继承。)
公共方法 ToString (从 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.

Thread Safety

此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。

示例

在 SMO 中配置 SQL Server

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

在 SMO 中配置 SQL Server

sp_configure (Transact-SQL)