DatabaseOptions Properties

DatabaseOptions Properties

 

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_pubpropertyAutoCreateStatistics

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

System_CAPS_pubpropertyAutoCreateStatisticsIncremental

Gets a property value that specifies whether the incremental statistics are automatically created for the database.

System_CAPS_pubpropertyAutoShrink

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

System_CAPS_pubpropertyAutoUpdateStatistics

Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICS 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_pubpropertyBrokerEnabled

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

System_CAPS_pubpropertyCloseCursorsOnCommitEnabled

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

System_CAPS_pubpropertyConcatenateNullYieldsNull

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

System_CAPS_pubpropertyDatabaseOwnershipChaining

Gets or sets a Boolean property value that specifies whether the database ownership chaining is active.

System_CAPS_pubpropertyDateCorrelationOptimization

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

System_CAPS_pubpropertyIsParameterizationForced

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

System_CAPS_pubpropertyLocalCursorsDefault

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

System_CAPS_pubpropertyMirroringRedoQueueMaxSize

Gets or sets the maximum size of the redo queue of the mirror server instance in KB.

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_pubpropertyNumericRoundAbortEnabled

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

System_CAPS_pubpropertyPageVerify

Specifies the type of page integrity check that Microsoft SQL Server performs when reading database pages.

System_CAPS_pubpropertyParent

Gets the Database object that is the parent of the DatabaseOptions object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.

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_pubpropertySnapshotIsolationState

Gets the snapshot isolation state for the database.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

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_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserAccess

Gets or sets the database user access.

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft