IServerConfigurationFacet Interface
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")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<CLSCompliantAttribute(False)> _
Public Interface IServerConfigurationFacet _
Inherits IDmfFacet
'Usage
Dim instance As IServerConfigurationFacet
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[StateChangeEventAttribute("AUDIT_SERVER_OPERATION_EVENT", "SERVER")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[CLSCompliantAttribute(false)]
public interface IServerConfigurationFacet : IDmfFacet
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[StateChangeEventAttribute(L"AUDIT_SERVER_OPERATION_EVENT", L"SERVER")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[CLSCompliantAttribute(false)]
public interface class IServerConfigurationFacet : IDmfFacet
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<StateChangeEventAttribute("AUDIT_SERVER_OPERATION_EVENT", "SERVER")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<CLSCompliantAttribute(false)>]
type IServerConfigurationFacet =
interface
interface IDmfFacet
end
public interface IServerConfigurationFacet extends IDmfFacet
The IServerConfigurationFacet type exposes the following members.
Properties
Name | Description | |
---|---|---|
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 the affinity64 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. | |
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 value of the FullTextCrawlBandwidthMax property. | |
FullTextCrawlBandwidthMin | Gets or sets the value of the FullTextCrawlBandwidthMin property. | |
FullTextCrawlRangeMax | Gets or sets the value of the FullTextCrawlRangeMax property. | |
FullTextNotifyBandwidthMax | Gets or sets the value of the FullTextNotifyBandwidthMax property. | |
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 the MediaRetention property value. | |
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 QueryGovenorCostLimit property value. | |
QueryWait | Gets or sets the QueryWait property value. | |
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 the UserConnections property value. | |
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