Export (0) Print
Expand All

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)

[StateChangeEventAttribute(L"AUDIT_SERVER_OPERATION_EVENT", L"SERVER")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
public interface class IServerConfigurationFacet : IDmfFacet

The IServerConfigurationFacet type exposes the following members.

  NameDescription
Public propertyAdHocRemoteQueriesEnabledGets or sets a Boolean value that specifies whether ad hoc remote queries are enabled.
Public propertyAffinity64IOMaskGets the affinity64 IO mask for a server.
Public propertyAffinity64MaskGets or sets the affinity 64 mask for a server.
Public propertyAffinityIOMaskGets the affinity IO mask for a server.
Public propertyAffinityMaskGets the affinity mask for a server.
Public propertyAgentXPsEnabledGets or sets a Boolean value that specifies whether the SQL Server Agent extended stored procedures are enabled.
Public propertyAllowUpdatesGets or sets a Boolean value that specifies specifying if the allow updates option is set.
Public propertyAweEnabledGets a Boolean value that specifies if the awe enabled value is set.
Public propertyBlockedProcessThresholdGets or sets the blocked process threshold.
Public propertyC2AuditTracingEnabledGets a Boolean value that specifies if the C2 audit tracing is set.
Public propertyClrIntegrationEnabledGets or sets a Boolean value that specifies if the CLR integration value is set.
Public propertyCommonCriteriaComplianceEnabledGets a Boolean value that specifies if the common criteria compliance value is set.
Public propertyContainmentEnabledGets the value that indicates whether the containment is enabled.
Public propertyCostThresholdForParallelismReturns the value contained in the cost threshold for parallelism property.
Public propertyCrossDBOwnershipChainingEnabledGets or sets a Boolean value that specifies if the cross DBOwnership chaining value is set.
Public propertyCursorThresholdGets or sets the cursor threshold value.
Public propertyDatabaseMailEnabledGets a Boolean value that specifies if the DatabaseMailEnabled property is set.
Public propertyDefaultBackupCompressionEnabledGets or sets a Boolean value that specifies if the BackupCompressionEnabled option is set.
Public propertyDefaultFullTextLanguageGets or sets the DefaultFullTextLanguage property.
Public propertyDefaultLanguageGets or sets the DefaultLanguage property.
Public propertyDefaultTraceEnabledGets or sets a Boolean value that specifies if the DefaultTraceEnabled property is set.
Public propertyDisallowResultsFromTriggersGets or sets a Boolean value that specifies if the DisallowResultsFromTriggers property is set.
Public propertyDynamicLocksGets the value of the DynamicLocks property.
Public propertyExtensibleKeyManagementEnabledGets a Boolean value that specifies if the ExtensibleKeyManagementEnabled property is set.
Public propertyFilestreamAccessLevelGets or sets the level of access permitted on the servers FILESTREAM operations.
Public propertyFillFactorGets the value of the FillFactor property.
Public propertyFullTextCrawlBandwidthMaxGets or sets the maximum value of the full text crawl bandwidth.
Public propertyFullTextCrawlBandwidthMinGets or sets the minimum value of the full text crawl bandwidth.
Public propertyFullTextCrawlRangeMaxGets or sets the maximum value of the full text crawl range.
Public propertyFullTextNotifyBandwidthMaxGets or sets the maximum value of the full text notify bandwidth.
Public propertyFullTextNotifyBandwidthMinGets or sets the FullTextNotifyBandwidthMin property value.
Public propertyIndexCreateMemoryGets or sets the IndexCreateMemory property value.
Public propertyInDoubtTransactionResolutionGets or sets the InDoubtTransactionResolutionType property value.
Public propertyLightweightPoolingEnabledGets a Boolean value that specifies if the LightweightPoolingEnabled property value is set.
Public propertyMaxDegreeOfParallelismGets or sets the MaxDegreeOfParallelism property value.
Public propertyMaxServerMemoryGets or sets the MaxServerMemory property value.
Public propertyMaxWorkerThreadsGets the MaxWorkerThreads property value.
Public propertyMediaRetentionGets or sets the media retention.
Public propertyMinMemoryPerQueryGets or set the MinMemoryPerQuery property value.
Public propertyMinServerMemoryGets or sets the MinServerMemory property value.
Public propertyNestedTriggersEnabledGets or sets a Boolean value that specifies if the NestedTriggersEnabled property value is set.
Public propertyNetworkPacketSizeGets or sets the NetworkPacketSize property value.
Public propertyOleAutomationEnabledGets or sets a Boolean value that specifies if the OleAutomationEnabled property value is set.
Public propertyOpenObjectsGets the OpenObjects property value.
Public propertyOptimizeAdhocWorkloadsGets or sets a value that determines whether ad hoc workloads will be optimized.
Public propertyPrecomputeRankGets or sets a Boolean value that specifies if the PrecomputeRank property value is set.
Public propertyPriorityBoostGets a Boolean value that specifies if the PriorityBoost property value is set.
Public propertyProtocolHandlerTimeoutGets or sets the ProtocolHandlerTimeout property value.
Public propertyQueryGovernorCostLimitGets or sets the maximum estimated cost allowed by query governor.
Public propertyQueryWaitGets or sets the query wait.
Public propertyRecoveryIntervalGets or sets the RecoveryInterval property value.
Public propertyRemoteAccessEnabledGets a Boolean value that specifies if the RemoteAccessEnabled property has been set.
Public propertyRemoteDacEnabledGets or sets a Boolean value that specifies if the RemoteDacEnabled property is set.
Public propertyRemoteLoginTimeoutGets or sets the RemoteLoginTimeout property value.
Public propertyRemoteProcTransEnabledGets or sets a Boolean value that specifies if the RemoteProcTransEnabled is set.
Public propertyRemoteQueryTimeoutGets or sets the RemoteQueryTimeout property value.
Public propertyReplicationMaxTextSizeGets or sets the ReplicationMaxTextSize property value.
Public propertyReplicationXPsEnabledGets or sets a Boolean value that specifies if the ReplicationXPsEnabled property is set.
Public propertyScanForStartupProceduresGets or sets a Boolean value that specifies if the ScanForStartupProcedures property is set.
Public propertyServerTriggerRecursionEnabledGets or sets a Boolean value that specifies if the ServerTriggerRecursionEnabled property is set.
Public propertySetWorkingSetSizeGets a Boolean value that specifies if the SetWorkingSetSize property value is set.
Public propertyShowAdvancedOptionsGets or sets a Boolean value that specifies if the ShowAdvancedOptions property value is set.
Public propertySmoAndDmoXPsEnabledGets or sets a Boolean value that specifies if the SmoAndDmoSPsEnabled property value is set.
Public propertySqlMailEnabledGets or sets a Boolean value that specifies if the SqlMailEnabled property value is set.
Public propertyTransformNoiseWordsGets or sets a Boolean value that specifies if the TransformNoiseWords property value is set.
Public propertyTwoDigitYearCutoffGets or sets the TwoDigitYearCutoff property value.
Public propertyUserConnectionsGets or sets the connections of the user.
Public propertyUserInstancesEnabledGets or sets a Boolean value that specifies if the UserInstancesEnabled property value is set.
Public propertyUserInstanceTimeoutGets or sets the UserInstanceTimeout property value.
Public propertyUserOptionsGets or sets the UserOptions property value.
Public propertyWebAssistantEnabledGets or sets a Boolean value that specifies if the WebAssistantEnabled property value is set
Public propertyXPCmdShellEnabledGets or sets a Boolean value that specifies if the XPCmdShellEnabled property is set.
Top

Community Additions

ADD
Show:
© 2014 Microsoft