Membri IServerConfigurationFacet

Contains configuration information for the interface based on Configuration

Il tipo IServerConfigurationFacet espone i membri seguenti.

Proprietà

	Nome	Descrizione
	AdHocRemoteQueriesEnabled	Gets or sets a Boolean value that specifies if 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 if 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
	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
	PrecomputeRank	Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set.
	PriorityBoost	Gets or 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.

In alto

Vedere anche

Riferimento

IServerConfigurationFacet Interfaccia

Spazio dei nomi Microsoft.SqlServer.Management.Smo