문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

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 : ConfigurationBase

Configuration 유형에서 다음 멤버를 표시합니다.

  이름설명
공용 속성AdHocDistributedQueriesEnabledGets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.
공용 속성Affinity64IOMaskGets the ConfigProperty object that is used to set the affinity 64 IO mask configuration option.
공용 속성Affinity64MaskGets the ConfigProperty object that is used to set the affinity 64 mask configuration option.
공용 속성AffinityIOMaskGets the ConfigProperty object that is used to set the affinity IO mask configuration option.
공용 속성AffinityMaskGets the ConfigProperty object that is used to set the affinity mask configuration option.
공용 속성AgentXPsEnabledGets the ConfigProperty object that is used to set the agent XPs enabled configuration option.
공용 속성AllowUpdatesGets 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.
공용 속성BlockedProcessThresholdGets the ConfigProperty object that sets the blocked process threshold configuration option.
공용 속성C2AuditModeGets the ConfigProperty object that is used to set the C2 audit mode configuration option.
공용 속성CommonCriteriaComplianceEnabledGets the ConfigProperty object that is used to set the common criteria compliance enabled configuration option.
공용 속성ContainmentEnabledGets the ConfigProperty object that is used to set the CONTAINMENT enabled configuration option.
공용 속성CostThresholdForParallelismGets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.
공용 속성CrossDBOwnershipChainingGets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option.
공용 속성CursorThresholdGets the ConfigProperty object that is used to set the cursor threshold configuration option.
공용 속성DatabaseMailEnabledGets the ConfigProperty object that is used to set the database mail enabled configuration option.
공용 속성DefaultBackupCompressionGets the ConfigProperty object that is used to set the default backup compression configuration option.
공용 속성DefaultFullTextLanguageGets the ConfigProperty object that is used to set default full text language configuration option.
공용 속성DefaultLanguageGets the ConfigProperty object that is used to set the default language configuration option.
공용 속성DefaultTraceEnabledGets the ConfigProperty object that is used to set the default trace enabled configuration option.
공용 속성DisallowResultsFromTriggersGets the ConfigProperty object that is used to set the disallow results from triggers configuration option.
공용 속성ExtensibleKeyManagementEnabledGets the ConfigProperty object that is used to set the extensible key management enabled configuration option.
공용 속성FilestreamAccessLevelGets the ConfigProperty object that sets the FILESTREAM access level configuration option.
공용 속성FillFactorGets the ConfigProperty object that is used to set the fill factor configuration option.
공용 속성FullTextCrawlBandwidthMaxGets the ConfigProperty object that is used to set the full text crawl bandwith max configuration option.
공용 속성FullTextCrawlBandwidthMinGets the ConfigProperty object that is used to set the full text crawl bandwith min configuration option.
공용 속성FullTextCrawlRangeMaxGets the ConfigProperty object that is used to set the full text crawl range max configuration option.
공용 속성FullTextNotifyBandwidthMaxGets the ConfigProperty object that is used to set the full text notify bandwith max configuration option.
공용 속성FullTextNotifyBandwidthMinGets the ConfigProperty object that is used to set the full text notify bandwith min configuration option.
공용 속성IndexCreateMemoryGets the ConfigProperty object that is used to set the index create memory configuration option.
공용 속성InDoubtTransactionResolutionGets the ConfigProperty object that is used to set the in doubt transaction resolution configuration option.
공용 속성IsSqlClrEnabledGets the ConfigProperty object that is used to set the is SQL Server CLR enabled configuration option.
공용 속성LightweightPoolingGets the ConfigProperty object that is used to set the lightweight pooling configuration option.
공용 속성LocksGets the ConfigProperty object that is used to set the locks configuration option.
공용 속성MaxDegreeOfParallelismGets the ConfigProperty object that is used to set the max degree of parallelism configuration option.
공용 속성MaxServerMemoryGets the ConfigProperty object that is used to set the max server memory configuration option.
공용 속성MaxWorkerThreadsGets the ConfigProperty object that is used to set the max worker threads configuration option.
공용 속성MediaRetentionGets the ConfigProperty object that is used to set the media retention configuration option.
공용 속성MinMemoryPerQueryGets the ConfigProperty object that is used to set the min memory per query configuration option.
공용 속성MinServerMemoryGets the ConfigProperty object that is used to set the min server memory configuration option.
공용 속성NestedTriggersGets the ConfigProperty object that is used to set the nested triggers configuration option.
공용 속성NetworkPacketSizeGets the ConfigProperty object that is used to set the network packet size configuration option.
공용 속성OleAutomationProceduresEnabledGets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option.
공용 속성OpenObjectsGets the ConfigProperty object that is used to set the open objects configuration option.
공용 속성OptimizeAdhocWorkloadsGets the ConfigProperty object that sets the optimize ad hoc workloads configuration option.
공용 속성ParentGets the Server object that is the parent of the Configuration object. (ConfigurationBase에서 상속됨)
공용 속성PrecomputeRankGets the ConfigProperty object that is used to set the precompute rank configuration option.
공용 속성PriorityBoostGets the ConfigProperty object that is used to set the priority boost configuration option.
공용 속성PropertiesReturns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object.
공용 속성ProtocolHandlerTimeoutGets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option.
공용 속성QueryGovernorCostLimitGets the ConfigProperty object that is used to set the query governor cost limit option.
공용 속성QueryWaitGets the ConfigProperty object that is used to set the query wait configuration option.
공용 속성RecoveryIntervalGets the ConfigProperty object that is used to set the recovery interval configuration option.
공용 속성RemoteAccessGets the ConfigProperty object that is used to set the remote access configuration option.
공용 속성RemoteDacConnectionsEnabledGets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option.
공용 속성RemoteLoginTimeoutGets the ConfigProperty object that is used to set the remote login timeout configuration option.
공용 속성RemoteProcTransGets the ConfigProperty object that is used to set the remote proc trans configuration option.
공용 속성RemoteQueryTimeoutGets the ConfigProperty object that is used to set the remote query timeout configuration option.
공용 속성ReplicationMaxTextSizeGets the ConfigProperty object that is used to set the replication max text size configuration option.
공용 속성ReplicationXPsEnabledGets the ConfigProperty object that is used to set the replication XPs enabled configuration option.
공용 속성ScanForStartupProceduresGets the ConfigProperty object that is used to set the scan for startup procedures configuration option.
공용 속성ServerTriggerRecursionEnabledGets the ConfigProperty object that is used to set the server trigger recursion enabled configuration option.
공용 속성SetWorkingSetSizeGets the ConfigProperty object that is used to set the set working set size configuration option.
공용 속성ShowAdvancedOptionsGets the ConfigProperty object that is used to set the show advanced options configuration option.
공용 속성SmoAndDmoXPsEnabledGets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option.
공용 속성SqlMailXPsEnabledGets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option.
공용 속성TransformNoiseWordsGets the ConfigProperty object that is used to set the transform noise words configuration option.
공용 속성TwoDigitYearCutoffGets the ConfigProperty object that is used to set the two digit year cutoff configuration option.
공용 속성UserConnectionsGets the ConfigProperty object that is used to set the user connections configuration option.
공용 속성UserInstancesEnabledGets the ConfigProperty object that is used to set the user instances enabled configuration option.
공용 속성UserInstanceTimeoutGets the ConfigProperty object that is used to set the user instance timeout configuration option.
공용 속성UserOptionsGets the ConfigProperty object that is used to set the user options configuration option.
공용 속성WebXPsEnabledGets the ConfigProperty object that is used to set the web XPs enabled configuration option.
공용 속성XPCmdShellEnabledGets 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에서 상속됨)
공용 메서드RefreshRefreshes 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의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

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

커뮤니티 추가 항목

추가
표시: