Export (0) Print
Expand All
Expand Minimize

DatabaseOptionKind Enumeration

Specifies the kinds of database options.

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

public enum DatabaseOptionKind

Member nameDescription
AllowSnapshotIsolationThe AllowSnapshotIsolation option.
AnsiNullDefaultThe AnsiNullDefault option.
AnsiNullsThe AnsiNulls option.
AnsiPaddingThe AnsiPadding option.
AnsiWarningsThe AnsiWarnings option.
ArithAbortThe ArithAbort option.
AutoCloseThe AutoClose option.
AutoCreateStatisticsThe AutoCreateStatistics option.
AutoShrinkThe AutoShrink option.
AutoUpdateStatisticsThe AutoUpdateStatistics option.
AutoUpdateStatisticsAsyncThe AutoUpdateStatisticsAsync option.
ChangeTrackingThe ChangeTracking option.
CompatibilityLevelThe CompatibilityLevel option.
ConcatNullYieldsNullThe ConcatNullYieldsNull option.
ContainmentThe Containment option.
CursorCloseOnCommitThe CursorCloseOnCommit option.
CursorDefaultThe CursorDefault option.
DateCorrelationOptimizationThe DateCorrelationOptimization option.
DBChainingThe DBChaining option.
DefaultFullTextLanguageThe DefaultFullTextLanguage option.
DefaultLanguageThe DefaultLanguage option.
DelayedDurability
DisableBrokerThe DisableBroker option.
EditionThe Edition option.
EmergencyThe Emergency option.
EnableBrokerThe EnableBroker option.
EncryptionThe Encryption option.
ErrorBrokerConversationsThe ErrorBrokerConversations option.
FileStreamThe FileStream option.
HadrThe Hadr option.
HonorBrokerPriorityThe HonorBrokerPriority option.
MaxSizeThe MaxSize option.
MemoryOptimizedDataThe MemoryOptimizedData option.
MemoryOptimizedElevateToSnapshot
MultiUserThe MultiUser option.
NestedTriggersThe NestedTriggers option.
NewBrokerThe NewBroker option.
NumericRoundAbortThe NumericRoundAbort option.
OfflineThe Offline option.
OnlineThe Online option.
PageVerifyThe PageVerify option.
ParameterizationThe Parameterization option.
PartnerThe Partner option.
QuotedIdentifierThe QuotedIdentifier option.
ReadCommittedSnapshotThe ReadCommittedSnapshot option.
ReadOnlyThe ReadOnly option.
ReadWriteThe ReadWrite option.
RecoveryThe Recovery option.
RecursiveTriggersThe RecursiveTriggers option.
RestrictedUserThe RestrictedUser option.
SingleUserThe SingleUser option.
SupplementalLoggingThe SupplementalLogging option.
TargetRecoveryTimeThe TargetRecoveryTime option.
TornPageDetectionThe TornPageDetection option.
TransformNoiseWordsThe TransformNoiseWords option.
TrustworthyThe Trustworthy option.
TwoDigitYearCutoffThe TwoDigitYearCutoff option.
VarDecimalStorageFormatThe VarDecimalStorageFormat option.
WitnessThe Witness option.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft