• Article

IDatabaseOptions Members

Include Protected Members
Include Inherited Members

Interface with properties that expose database options.

The IDatabaseOptions type exposes the following members.

Properties

  Name Description
Public property AnsiNullDefault Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.
Public property AnsiNullsEnabled Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.
Public property AnsiPaddingEnabled Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.
Public property AnsiWarningsEnabled Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.
Public property ArithmeticAbortEnabled Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.
Public property AutoClose Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
Public property AutoCreateStatisticsEnabled
Public property AutoShrink Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.
Public property AutoUpdateStatisticsAsync Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
Public property AutoUpdateStatisticsEnabled
Public property BrokerEnabled Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled.
Public property ChangeTrackingAutoCleanUp
Public property ChangeTrackingEnabled
Public property ChangeTrackingRetentionPeriod
Public property ChangeTrackingRetentionPeriodUnits
Public property CloseCursorsOnCommitEnabled Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
Public property Collation
Public property CompatibilityLevel
Public property ConcatenateNullYieldsNull Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
Public property CreateDate
Public property DatabaseOwnershipChaining
Public property DatabaseSnapshotBaseName
Public property DateCorrelationOptimization Gets or sets a Boolean property value that specifies whether the date correlation optimization is active.
Public property DefaultFileGroup
Public property DefaultFileStreamFileGroup
Public property EncryptionEnabled
Public property HonorBrokerPriority
Public property ID
Public property IsParameterizationForced Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.
Public property IsReadCommittedSnapshotOn
Public property IsSystemObject
Public property IsUpdateable
Public property LocalCursorsDefault Gets the Boolean value that specifies whether the local server cursors are used by default.
Public property 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.
Public property Name
Public property NumericRoundAbortEnabled Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
Public property PageVerify Specifies the type of page integrity check that SQL Server performs when it reads database pages.
Public property PrimaryFilePath
Public property 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.
Public property ReadOnly Gets or sets the Boolean property value that specifies whether the database is read-only.
Public property RecoveryModel Gets or sets the recovery model for the database.
Public property RecursiveTriggersEnabled Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
Public property Trustworthy
Public property UserAccess Gets or sets the database user access.

Top