Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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