Membres IDatabaseOptions

Interface with properties that expose database options.

Le type IDatabaseOptions expose les membres suivants.

Propriétés

	Nom	Description
	AnsiNullDefault	Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.
	AnsiNullsEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.
	AnsiPaddingEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.
	AnsiWarningsEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.
	ArithmeticAbortEnabled	Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.
	AutoClose	Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
	AutoCreateStatisticsEnabled
	AutoShrink	Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.
	AutoUpdateStatisticsAsync	Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
	AutoUpdateStatisticsEnabled
	BrokerEnabled	Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled.
	ChangeTrackingAutoCleanUp
	ChangeTrackingEnabled
	ChangeTrackingRetentionPeriod
	ChangeTrackingRetentionPeriodUnits
	CloseCursorsOnCommitEnabled	Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
	Collation
	CompatibilityLevel
	ConcatenateNullYieldsNull	Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
	CreateDate
	DatabaseOwnershipChaining
	DatabaseSnapshotBaseName
	DateCorrelationOptimization	Gets or sets a Boolean property value that specifies whether the date correlation optimization is active.
	DefaultFileGroup
	DefaultFileStreamFileGroup
	EncryptionEnabled
	HonorBrokerPriority
	ID
	IsParameterizationForced	Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.
	IsReadCommittedSnapshotOn
	IsSystemObject
	IsUpdateable
	LocalCursorsDefault	Gets the Boolean value that specifies whether the local server cursors are used by default.
	MirroringTimeout	Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected.
	Name
	NumericRoundAbortEnabled	Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
	PageVerify	Specifies the type of page integrity check that SQL Server performs when it reads database pages.
	PrimaryFilePath
	QuotedIdentifiersEnabled	Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
	ReadOnly	Gets or sets the Boolean property value that specifies whether the database is read-only.
	RecoveryModel	Gets or sets the recovery model for the database.
	RecursiveTriggersEnabled	Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
	Trustworthy
	UserAccess	Gets or sets the database user access.

Haut de la page

Voir aussi

Référence

IDatabaseOptions Interface

Espace de noms Microsoft.SqlServer.Management.Smo