Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Contains configuration information for interfaces based on the Configuration object.
This API is not CLS-compliant.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<StateChangeEventAttribute("AUDIT_SERVER_OPERATION_EVENT", "SERVER")> _
<CLSCompliantAttribute(False)> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public Interface IServerConfigurationFacet _
Inherits IDmfFacet
'Usage
Dim instance As IServerConfigurationFacet
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[StateChangeEventAttribute("AUDIT_SERVER_OPERATION_EVENT", "SERVER")]
[CLSCompliantAttribute(false)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public interface IServerConfigurationFacet : IDmfFacet
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[StateChangeEventAttribute(L"AUDIT_SERVER_OPERATION_EVENT", L"SERVER")]
[CLSCompliantAttribute(false)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public interface class IServerConfigurationFacet : IDmfFacet
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<StateChangeEventAttribute("AUDIT_SERVER_OPERATION_EVENT", "SERVER")>]
[<CLSCompliantAttribute(false)>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
type IServerConfigurationFacet =
interface
interface IDmfFacet
end
public interface IServerConfigurationFacet extends IDmfFacet
The IServerConfigurationFacet type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
AdHocRemoteQueriesEnabled | Gets or sets a Boolean value that specifies whether ad hoc remote queries are enabled. |
|
Affinity64IOMask | Gets the affinity64 IO mask for a server. |
|
Affinity64Mask | Gets or sets the affinity 64 mask for a server. |
|
AffinityIOMask | Gets the affinity IO mask for a server. |
|
AffinityMask | Gets the affinity mask for a server. |
|
AgentXPsEnabled | Gets or sets a Boolean value that specifies whether the SQL Server Agent extended stored procedures are enabled. |
|
AllowUpdates | Gets or sets a Boolean value that specifies specifying if the allow updates option is set. |
|
AweEnabled | Gets a Boolean value that specifies if the awe enabled value is set. |
|
BlockedProcessThreshold | Gets or sets the blocked process threshold. |
|
C2AuditTracingEnabled | Gets a Boolean value that specifies if the C2 audit tracing is set. |
|
ClrIntegrationEnabled | Gets or sets a Boolean value that specifies if the CLR integration value is set. |
|
CommonCriteriaComplianceEnabled | Gets a Boolean value that specifies if the common criteria compliance value is set. |
|
ContainmentEnabled | Gets the value that indicates whether the containment is enabled. |
|
CostThresholdForParallelism | Returns the value contained in the cost threshold for parallelism property. |
|
CrossDBOwnershipChainingEnabled | Gets or sets a Boolean value that specifies if the cross DBOwnership chaining value is set. |
|
CursorThreshold | Gets or sets the cursor threshold value. |
|
DatabaseMailEnabled | Gets a Boolean value that specifies if the DatabaseMailEnabled property is set. |
|
DefaultBackupCompressionEnabled | Gets or sets a Boolean value that specifies if the BackupCompressionEnabled option is set. |
|
DefaultFullTextLanguage | Gets or sets the DefaultFullTextLanguage property. |
|
DefaultLanguage | Gets or sets the DefaultLanguage property. |
|
DefaultTraceEnabled | Gets or sets a Boolean value that specifies if the DefaultTraceEnabled property is set. |
|
DisallowResultsFromTriggers | Gets or sets a Boolean value that specifies if the DisallowResultsFromTriggers property is set. |
|
DynamicLocks | Gets the value of the DynamicLocks property. |
|
ExtensibleKeyManagementEnabled | Gets a Boolean value that specifies if the ExtensibleKeyManagementEnabled property is set. |
|
FilestreamAccessLevel | Gets or sets the level of access permitted on the servers FILESTREAM operations. |
|
FillFactor | Gets the value of the FillFactor property. |
|
FullTextCrawlBandwidthMax | Gets or sets the maximum value of the full text crawl bandwidth. |
|
FullTextCrawlBandwidthMin | Gets or sets the minimum value of the full text crawl bandwidth. |
|
FullTextCrawlRangeMax | Gets or sets the maximum value of the full text crawl range. |
|
FullTextNotifyBandwidthMax | Gets or sets the maximum value of the full text notify bandwidth. |
|
FullTextNotifyBandwidthMin | Gets or sets the FullTextNotifyBandwidthMin property value. |
|
IndexCreateMemory | Gets or sets the IndexCreateMemory property value. |
|
InDoubtTransactionResolution | Gets or sets the InDoubtTransactionResolutionType property value. |
|
LightweightPoolingEnabled | Gets a Boolean value that specifies if the LightweightPoolingEnabled property value is set. |
|
MaxDegreeOfParallelism | Gets or sets the MaxDegreeOfParallelism property value. |
|
MaxServerMemory | Gets or sets the MaxServerMemory property value. |
|
MaxWorkerThreads | Gets the MaxWorkerThreads property value. |
|
MediaRetention | Gets or sets the media retention. |
|
MinMemoryPerQuery | Gets or set the MinMemoryPerQuery property value. |
|
MinServerMemory | Gets or sets the MinServerMemory property value. |
|
NestedTriggersEnabled | Gets or sets a Boolean value that specifies if the NestedTriggersEnabled property value is set. |
|
NetworkPacketSize | Gets or sets the NetworkPacketSize property value. |
|
OleAutomationEnabled | Gets or sets a Boolean value that specifies if the OleAutomationEnabled property value is set. |
|
OpenObjects | Gets the OpenObjects property value. |
|
OptimizeAdhocWorkloads | Gets or sets a value that determines whether ad hoc workloads will be optimized. |
|
PrecomputeRank | Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set. |
|
PriorityBoost | Gets a Boolean value that specifies if the PriorityBoost property value is set. |
|
ProtocolHandlerTimeout | Gets or sets the ProtocolHandlerTimeout property value. |
|
QueryGovernorCostLimit | Gets or sets the maximum estimated cost allowed by query governor. |
|
QueryWait | Gets or sets the query wait. |
|
RecoveryInterval | Gets or sets the RecoveryInterval property value. |
|
RemoteAccessEnabled | Gets a Boolean value that specifies if the RemoteAccessEnabled property has been set. |
|
RemoteDacEnabled | Gets or sets a Boolean value that specifies if the RemoteDacEnabled property is set. |
|
RemoteLoginTimeout | Gets or sets the RemoteLoginTimeout property value. |
|
RemoteProcTransEnabled | Gets or sets a Boolean value that specifies if the RemoteProcTransEnabled is set. |
|
RemoteQueryTimeout | Gets or sets the RemoteQueryTimeout property value. |
|
ReplicationMaxTextSize | Gets or sets the ReplicationMaxTextSize property value. |
|
ReplicationXPsEnabled | Gets or sets a Boolean value that specifies if the ReplicationXPsEnabled property is set. |
|
ScanForStartupProcedures | Gets or sets a Boolean value that specifies if the ScanForStartupProcedures property is set. |
|
ServerTriggerRecursionEnabled | Gets or sets a Boolean value that specifies if the ServerTriggerRecursionEnabled property is set. |
|
SetWorkingSetSize | Gets a Boolean value that specifies if the SetWorkingSetSize property value is set. |
|
ShowAdvancedOptions | Gets or sets a Boolean value that specifies if the ShowAdvancedOptions property value is set. |
|
SmoAndDmoXPsEnabled | Gets or sets a Boolean value that specifies if the SmoAndDmoSPsEnabled property value is set. |
|
SqlMailEnabled | Gets or sets a Boolean value that specifies if the SqlMailEnabled property value is set. |
|
TransformNoiseWords | Gets or sets a Boolean value that specifies if the TransformNoiseWords property value is set. |
|
TwoDigitYearCutoff | Gets or sets the TwoDigitYearCutoff property value. |
|
UserConnections | Gets or sets the connections of the user. |
|
UserInstancesEnabled | Gets or sets a Boolean value that specifies if the UserInstancesEnabled property value is set. |
|
UserInstanceTimeout | Gets or sets the UserInstanceTimeout property value. |
|
UserOptions | Gets or sets the UserOptions property value. |
|
WebAssistantEnabled | Gets or sets a Boolean value that specifies if the WebAssistantEnabled property value is set |
|
XPCmdShellEnabled | Gets or sets a Boolean value that specifies if the XPCmdShellEnabled property is set. |
Top