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)

Syntax

'Declaration
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayDescriptionKeyAttribute("IDatabaseOptions_Desc")> _
<CLSCompliantAttribute(False)> _
<StateChangeEventAttribute("CREATE_DATABASE", "DATABASE")> _
<StateChangeEventAttribute("ALTER_DATABASE", "DATABASE")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "DATABASE")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayNameKeyAttribute("IDatabaseOptions_Name")> _
Public Interface IDatabaseOptions _
    Inherits IDmfFacet
'Usage
Dim instance As IDatabaseOptions

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

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

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

public interface IDatabaseOptions extends IDmfFacet

The IDatabaseOptions type exposes the following members.

Properties

	Name	Description
	AnsiNullDefault	Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active.
	AnsiNullsEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active.
	AnsiPaddingEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active.
	AnsiWarningsEnabled	Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active.
	ArithmeticAbortEnabled	Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active.
	AutoClose	Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
	AutoCreateStatisticsEnabled	Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active.
	AutoShrink	Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active.
	AutoUpdateStatisticsAsync	Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active.
	AutoUpdateStatisticsEnabled	Specifies whether database statistics are automatically updated.
	BrokerEnabled	Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled.
	ChangeTrackingAutoCleanUp	Gets or sets a Boolean property value that specifies whether the CHANGE_TRACKING_AUTO_CLEANUP OPTION is enabled.
	ChangeTrackingEnabled	Gets or sets a value indicating whether change tracking is enabled.
	ChangeTrackingRetentionPeriod	Gets or sets an interval that specifies how long change tracking information is retained.
	ChangeTrackingRetentionPeriodUnits	Specifies the units for the change tracking retention period.
	CloseCursorsOnCommitEnabled	Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.
	Collation	Gets or sets the default collation used by the database.
	CompatibilityLevel	Gets or sets the compatibility level for a database.
	ConcatenateNullYieldsNull	Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active.
	CreateDate	Gets the date and time at which the database was created.
	DatabaseOwnershipChaining	Indicates whether property ownership chaining is active.
	DatabaseSnapshotBaseName	Gets the name of shapshot base for the database.
	DateCorrelationOptimization	Gets or sets a Boolean property value that specifies whether the date correlation optimization is active.
	DefaultFileGroup	Gets the default file group used by the database.
	DefaultFileStreamFileGroup	Gets the default stream file group used by the database.
	EncryptionEnabled	Gets or sets a value indicating whether encryption is enabled for the database.
	HonorBrokerPriority	Gets or sets a value that indicates whether the priority specified by the broker is acknowledged.
	ID	Gets the database ID value.
	IsParameterizationForced	Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.
	IsReadCommittedSnapshotOn	Gets a value that specifies whether transactions with the read committed isolation level use row versioning.
	IsSystemObject	Specifies whether the database is a system object or a user-defined database.
	IsUpdateable	Indicates whether the database is updateable.
	LocalCursorsDefault	Gets the Boolean value that specifies whether the local server cursors are used by default.
	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	Gets the name of the database.
	NumericRoundAbortEnabled	Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active.
	Owner	Gets the the owner of the database.
	PageVerify	Specifies the type of page integrity check that SQL Server performs when it reads database pages.
	PrimaryFilePath	Gets the primary database file path.
	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	Gets or sets the Boolean property value that specifies whether the database is read-only.
	RecoveryModel	Gets or sets the recovery model for the database.
	RecursiveTriggersEnabled	Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database.
	TargetRecoveryTime	Gets or sets the target recovery time.
	Trustworthy	The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it.
	UserAccess	Gets or sets the database user access.

Top

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace