Export (0) Print
Expand All

IDatabaseOptions Interface

Interface with properties that expose database options.

This API is not CLS-compliant. 

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

[CLSCompliantAttribute(false)]
[DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")]
[StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")]
[StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("IDatabaseOptions_Name")]
public interface IDatabaseOptions : IDmfFacet

The IDatabaseOptions type exposes the following members.

  NameDescription
Public propertyAnsiNullDefaultGets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.
Public propertyAnsiNullsEnabledGets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.
Public propertyAnsiPaddingEnabledGets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.
Public propertyAnsiWarningsEnabledGets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.
Public propertyArithmeticAbortEnabledGets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.
Public propertyAutoCloseGets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
Public propertyAutoCreateStatisticsEnabledGets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active.
Public propertyAutoShrinkGets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.
Public propertyAutoUpdateStatisticsAsyncGets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
Public propertyAutoUpdateStatisticsEnabledSpecifies whether database statistics are automatically updated.
Public propertyBrokerEnabledGets or sets a Boolean property value that specifies whether the Service Broker service is enabled.
Public propertyChangeTrackingAutoCleanUpGets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.
Public propertyChangeTrackingEnabledGets or sets a value indicating whether change tracking is enabled.
Public propertyChangeTrackingRetentionPeriodGets or sets an interval that specifies how long change tracking information is retained.
Public propertyChangeTrackingRetentionPeriodUnitsSpecifies the units for the change tracking retention period.
Public propertyCloseCursorsOnCommitEnabledGets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
Public propertyCollationGets or sets the default collation used by the database.
Public propertyCompatibilityLevelGets or sets the compatibility level for a database.
Public propertyConcatenateNullYieldsNullGets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
Public propertyCreateDateGets the date and time at which the database was created.
Public propertyDatabaseOwnershipChainingIndicates whether property ownership chaining is active.
Public propertyDatabaseSnapshotBaseNameGets the name of shapshot base for the database.
Public propertyDateCorrelationOptimizationGets or sets a Boolean property value that specifies whether the date correlation optimization is active.
Public propertyDefaultFileGroupGets the default file group used by the database.
Public propertyDefaultFileStreamFileGroupGets the default stream file group used by the database.
Public propertyEncryptionEnabledGets or sets a value indicating whether encryption is enabled for the database.
Public propertyHonorBrokerPriorityGets or sets a value that indicates whether the priority specified by the broker is acknowledged.
Public propertyIDGets the database ID value.
Public propertyIsParameterizationForcedGets or sets a Boolean property value that specifies whether parameterization is forced on the database.
Public propertyIsReadCommittedSnapshotOnGets a value that specifies whether transactions with the read committed isolation level use row versioning.
Public propertyIsSystemObjectSpecifies whether the database is a system object or a user-defined database.
Public propertyIsUpdateableIndicates whether the database is updateable.
Public propertyLocalCursorsDefaultGets the Boolean value that specifies whether the local server cursors are used by default.
Public propertyMirroringTimeoutGets 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 propertyNameGets the name of the database.
Public propertyNumericRoundAbortEnabledGets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
Public propertyOwnerGets the the owner of the database.
Public propertyPageVerifySpecifies the type of page integrity check that SQL Server performs when it reads database pages.
Public propertyPrimaryFilePathGets the primary database file path.
Public propertyQuotedIdentifiersEnabledGets 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 propertyReadOnlyGets or sets the Boolean property value that specifies whether the database is read-only.
Public propertyRecoveryModelGets or sets the recovery model for the database.
Public propertyRecursiveTriggersEnabledGets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
Public propertyTrustworthyThe TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it.
Public propertyUserAccessGets or sets the database user access.
Top

Community Additions

ADD
Show:
© 2014 Microsoft