Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

IDatabaseOptions Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullDefault

Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.

System_CAPS_pubpropertyAnsiNullsEnabled

Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.

System_CAPS_pubpropertyAnsiPaddingEnabled

Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.

System_CAPS_pubpropertyAnsiWarningsEnabled

Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.

System_CAPS_pubpropertyArithmeticAbortEnabled

Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.

System_CAPS_pubpropertyAutoClose

Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.

System_CAPS_pubpropertyAutoCreateIncrementalStatisticsEnabled

Gets or sets a Boolean property value that specifies whether the AUTOCREATEINCREMENTALSTATICTICS database option is active.

System_CAPS_pubpropertyAutoCreateStatisticsEnabled

Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active.

System_CAPS_pubpropertyAutoShrink

Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.

System_CAPS_pubpropertyAutoUpdateStatisticsAsync

Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.

System_CAPS_pubpropertyAutoUpdateStatisticsEnabled

Specifies whether database statistics are automatically updated.

System_CAPS_pubpropertyBrokerEnabled

Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled.

System_CAPS_pubpropertyChangeTrackingAutoCleanUp

Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.

System_CAPS_pubpropertyChangeTrackingEnabled

Gets or sets a value indicating whether change tracking is enabled.

System_CAPS_pubpropertyChangeTrackingRetentionPeriod

Gets or sets an interval that specifies how long change tracking information is retained.

System_CAPS_pubpropertyChangeTrackingRetentionPeriodUnits

Specifies the units for the change tracking retention period.

System_CAPS_pubpropertyCloseCursorsOnCommitEnabled

Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.

System_CAPS_pubpropertyCollation

Gets or sets the default collation used by the database.

System_CAPS_pubpropertyCompatibilityLevel

Gets or sets the compatibility level for a database.

System_CAPS_pubpropertyConcatenateNullYieldsNull

Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.

System_CAPS_pubpropertyCreateDate

Gets the date and time at which the database was created.

System_CAPS_pubpropertyDatabaseOwnershipChaining

Indicates whether property ownership chaining is active.

System_CAPS_pubpropertyDatabaseSnapshotBaseName

Gets the name of shapshot base for the database.

System_CAPS_pubpropertyDateCorrelationOptimization

Gets or sets a Boolean property value that specifies whether the date correlation optimization is active.

System_CAPS_pubpropertyDefaultFileGroup

Gets the default file group used by the database.

System_CAPS_pubpropertyDefaultFileStreamFileGroup

Gets the default stream file group used by the database.

System_CAPS_pubpropertyDelayedDurability

Gets or sets the delayed durability setting of a database.

System_CAPS_pubpropertyEncryptionEnabled

Gets or sets a value indicating whether encryption is enabled for the database.

System_CAPS_pubpropertyHonorBrokerPriority

Gets or sets a value that indicates whether the priority specified by the broker is acknowledged.

System_CAPS_pubpropertyID

Gets the database ID value.

System_CAPS_pubpropertyIsParameterizationForced

Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.

System_CAPS_pubpropertyIsReadCommittedSnapshotOn

Gets a value that specifies whether transactions with the read committed isolation level use row versioning.

System_CAPS_pubpropertyIsSystemObject

Specifies whether the database is a system object or a user-defined database.

System_CAPS_pubpropertyIsUpdateable

Indicates whether the database is updateable.

System_CAPS_pubpropertyLocalCursorsDefault

Gets the Boolean value that specifies whether the local server cursors are used by default.

System_CAPS_pubpropertyMirroringTimeout

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.

System_CAPS_pubpropertyName

Gets the name of the database.

System_CAPS_pubpropertyNumericRoundAbortEnabled

Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.

System_CAPS_pubpropertyOwner

Gets the the owner of the database.

System_CAPS_pubpropertyPageVerify

Specifies the type of page integrity check that SQL Server performs when it reads database pages.

System_CAPS_pubpropertyPrimaryFilePath

Gets the primary database file path.

System_CAPS_pubpropertyQuotedIdentifiersEnabled

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.

System_CAPS_pubpropertyReadOnly

Gets or sets the Boolean property value that specifies whether the database is read-only.

System_CAPS_pubpropertyRecoveryModel

Gets or sets the recovery model for the database.

System_CAPS_pubpropertyRecursiveTriggersEnabled

Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.

System_CAPS_pubpropertyTargetRecoveryTime

Gets or sets the target recovery time.

System_CAPS_pubpropertyTrustworthy

The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it.

System_CAPS_pubpropertyUserAccess

Gets or sets the database user access.

Return to top
Show:
© 2015 Microsoft