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

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

예

SMO에서 SQL Server 구성

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

SMO에서 SQL Server 구성

sp_configure(Transact-SQL)