IDatabaseOptions IDatabaseOptions IDatabaseOptions Interface

Definition

Important

This API is not CLS-compliant.

Represents an interface with properties that expose database options.

public interface class IDatabaseOptions : Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet
[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnChanges | Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("ALTER_AUTHORIZATION_DATABASE", "DATABASE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("CREATE_DATABASE", "DATABASE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("ALTER_DATABASE", "DATABASE")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayDescriptionKey("IDatabaseOptions_Desc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("IDatabaseOptions_Name")]
[Microsoft.SqlServer.Management.Sdk.Sfc.LocalizedPropertyResources("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[System.CLSCompliant(false)]
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter))]
public interface IDatabaseOptions : Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet
Public Interface IDatabaseOptions
Implements IDmfFacet
Derived
Attributes
Microsoft.SqlServer.Management.Facets.EvaluationModeAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute DisplayDescriptionKeyAttribute DisplayNameKeyAttribute LocalizedPropertyResourcesAttribute CLSCompliantAttribute TypeConverterAttribute
Implements

Properties

AnsiNullDefault AnsiNullDefault AnsiNullDefault

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

AnsiNullsEnabled AnsiNullsEnabled AnsiNullsEnabled

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

AnsiPaddingEnabled AnsiPaddingEnabled AnsiPaddingEnabled

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

AnsiWarningsEnabled AnsiWarningsEnabled AnsiWarningsEnabled

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

ArithmeticAbortEnabled ArithmeticAbortEnabled ArithmeticAbortEnabled

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

AutoClose AutoClose AutoClose

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

AutoCreateIncrementalStatisticsEnabled AutoCreateIncrementalStatisticsEnabled AutoCreateIncrementalStatisticsEnabled

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

AutoCreateStatisticsEnabled AutoCreateStatisticsEnabled AutoCreateStatisticsEnabled

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

AutoShrink AutoShrink AutoShrink

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

AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync

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

AutoUpdateStatisticsEnabled AutoUpdateStatisticsEnabled AutoUpdateStatisticsEnabled

Specifies whether database statistics are automatically updated.

BrokerEnabled BrokerEnabled BrokerEnabled

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

ChangeTrackingAutoCleanUp ChangeTrackingAutoCleanUp ChangeTrackingAutoCleanUp

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

ChangeTrackingEnabled ChangeTrackingEnabled ChangeTrackingEnabled

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

ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod

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

ChangeTrackingRetentionPeriodUnits ChangeTrackingRetentionPeriodUnits ChangeTrackingRetentionPeriodUnits

Specifies the units for the change tracking retention period.

CloseCursorsOnCommitEnabled CloseCursorsOnCommitEnabled CloseCursorsOnCommitEnabled

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

Collation Collation Collation

Gets or sets the default collation used by the database.

CompatibilityLevel CompatibilityLevel CompatibilityLevel

Gets or sets the compatibility level for a database.

ConcatenateNullYieldsNull ConcatenateNullYieldsNull ConcatenateNullYieldsNull

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

CreateDate CreateDate CreateDate

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

DatabaseOwnershipChaining DatabaseOwnershipChaining DatabaseOwnershipChaining

Indicates whether property ownership chaining is active.

DatabaseSnapshotBaseName DatabaseSnapshotBaseName DatabaseSnapshotBaseName

Gets the name of shapshot base for the database.

DateCorrelationOptimization DateCorrelationOptimization DateCorrelationOptimization

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

DefaultFileGroup DefaultFileGroup DefaultFileGroup

Gets the default file group used by the database.

DefaultFileStreamFileGroup DefaultFileStreamFileGroup DefaultFileStreamFileGroup

Gets the default stream file group used by the database.

DelayedDurability DelayedDurability DelayedDurability

Gets or sets the delayed durability setting of a database.

EncryptionEnabled EncryptionEnabled EncryptionEnabled

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

HonorBrokerPriority HonorBrokerPriority HonorBrokerPriority

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

ID ID ID

Gets the database ID value.

IsParameterizationForced IsParameterizationForced IsParameterizationForced

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

IsReadCommittedSnapshotOn IsReadCommittedSnapshotOn IsReadCommittedSnapshotOn

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

IsSystemObject IsSystemObject IsSystemObject

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

IsUpdateable IsUpdateable IsUpdateable

Indicates whether the database is updateable.

LocalCursorsDefault LocalCursorsDefault LocalCursorsDefault

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

MirroringTimeout MirroringTimeout 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.

Name Name Name

Gets the name of the database.

NumericRoundAbortEnabled NumericRoundAbortEnabled NumericRoundAbortEnabled

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

Owner Owner Owner

Gets the the owner of the database.

PageVerify PageVerify PageVerify

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

PrimaryFilePath PrimaryFilePath PrimaryFilePath

Gets the primary database file path.

QuotedIdentifiersEnabled QuotedIdentifiersEnabled 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.

ReadOnly ReadOnly ReadOnly

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

RecoveryModel RecoveryModel RecoveryModel

Gets or sets the recovery model for the database.

RecursiveTriggersEnabled RecursiveTriggersEnabled RecursiveTriggersEnabled

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

RemoteDataArchiveCredential RemoteDataArchiveCredential RemoteDataArchiveCredential

Gets the remote data archive credential.

RemoteDataArchiveEnabled RemoteDataArchiveEnabled RemoteDataArchiveEnabled

Gets or sets a value that indicates whether remote data archive is enabled.

RemoteDataArchiveEndpoint RemoteDataArchiveEndpoint RemoteDataArchiveEndpoint

Gets or sets the endpoint of the remote data.

RemoteDataArchiveLinkedServer RemoteDataArchiveLinkedServer RemoteDataArchiveLinkedServer

Gets the linked server of remote data archive.

RemoteDataArchiveUseFederatedServiceAccount RemoteDataArchiveUseFederatedServiceAccount RemoteDataArchiveUseFederatedServiceAccount

Gets a value indicating whether the remote data archive use federated service account.

RemoteDatabaseName RemoteDatabaseName RemoteDatabaseName

Gets the name of the remote database.

TargetRecoveryTime TargetRecoveryTime TargetRecoveryTime

Gets or sets the target recovery time.

Trustworthy Trustworthy Trustworthy

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

UserAccess UserAccess UserAccess

Gets or sets the database user access.

Applies to