TSqlModelOptions Properties
Updated: April 20, 2017
Assembly: Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)
| Name | Description | |
|---|---|---|
 | AllowSnapshotIsolation | Specifies the ALLOW_SNAPSHOT_ISOLATION database option. |
| AnsiNullDefaultOn | Specifies the ANSI_NULL_DEFAULT database option. |
| AnsiNullsOn | Specifies the ANSI_NULLS database option. |
| AnsiPaddingOn | Specifies the ANSI_PADDING database option. |
| AnsiWarningsOn | Specifies the ANSI_WARNINGS database option. |
| ArithAbortOn | Specifies the ARITH_ABORT database option. |
| AutoClose | Specifies the AUTO_CLOSE database option. |
| AutoCreateStatistics | Specifies the AUTO_CREATE_STATISTICS database option. |
| AutoCreateStatisticsIncremental | Specifies the AUTO_CREATE_STATISTICS INCREMENTAL database option. |
| AutoShrink | Specifies the AUTO_SHRINK database option. |
| AutoUpdateStatistics | Specifies the AUTO_UPDATE_STATISTICS database option. |
| AutoUpdateStatisticsAsync | Specifies the AUTO_UPDATE_STATISTICS_ASYNC database option. |
| ChangeTrackingAutoCleanup | Specifies the AUTO_CLEANUP database option. |
| ChangeTrackingEnabled | Specifies the CHANGE_TRACKING database option. |
| ChangeTrackingRetentionPeriod | Specifies the period of the CHANGE_RETENTION database option. |
| ChangeTrackingRetentionUnit | Specifies the unit of the CHANGE_RETENTION database option. |
| Collation | Specifies the Collation to use for the model. This is a string such as "SQL_Latin1_General_CP1_CI_AS", which must be a valid SQL Server Collation Name |
| CompatibilityLevel | Specifies the COMPATIBILITY_LEVEL database option. |
| ConcatNullYieldsNull | Specifies the CONCAT_NULL_YIELDS_NULL database option. |
| Containment | Specifies the CONTAINMENT database option. |
| CursorCloseOnCommit | Specifies the CURSOR_CLOSE_ON_COMMIT database option. |
| CursorDefaultGlobalScope | Specifies the CURSOR_DEFAULT database option. |
| DatabaseStateOffline | Specifies the ONLINE | OFFLINE database option. |
| DateCorrelationOptimizationOn | Specifies the DATE_CORRELATION_OPTIMIZATION database option. |
| DBChainingOn | Specifies the DB_CHAINING database option. |
| DbScopedConfigLegacyCardinalityEstimation | |
| DbScopedConfigLegacyCardinalityEstimationSecondary | |
| DbScopedConfigMaxDOP | |
| DbScopedConfigMaxDOPSecondary | |
| DbScopedConfigParameterSniffing | |
| DbScopedConfigParameterSniffingSecondary | |
| DbScopedConfigQueryOptimizerHotfixes | |
| DbScopedConfigQueryOptimizerHotfixesSecondary | |
| DefaultFullTextLanguage | Specifies the DEFAULT_FULLTEXT_LANGUAGE database option. |
| DefaultLanguage | Specifies the DEFAULT_LANGUAGE database option. |
| DelayedDurabilityMode | Specifies the DELAYED_DURABILITY database option. |
| EngineVersion | Specifies what engine version should be targeted by the model. For On Premises platforms this value will be ignored as the engine version is fixed based on the platform. For the SqlAzure platform this value will be set and used to specify what T-SQL language features are supported. |
| FileStreamDirectoryName | Specifies the DIRECTORY_NAME database option. |
| FullTextEnabled | Specifies the sp_fulltext_database database option. |
| HonorBrokerPriority | Specifies the HONOR_BROKER_PRIORITY database option. |
| MemoryOptimizedElevateToSnapshot | Specifies the MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT database option. |
| NestedTriggersOn | Specifies the NESTED_TRIGGER database option. |
| NonTransactedFileStreamAccess | Specifies the NON_TRANSACTED_ACCESS database option. |
| NumericRoundAbortOn | Specifies the NUMERIC_ROUNDABORT database option. |
| PageVerifyMode | Specifies the PAGE_VERIFY database option. |
| ParameterizationOption | Specifies the PARAMETERIZATION database option. |
| QueryStoreCaptureMode | |
| QueryStoreDesiredState | |
| QueryStoreFlushInterval | |
| QueryStoreIntervalLength | |
| QueryStoreMaxPlansPerQuery | |
| QueryStoreMaxStorageSize | |
| QueryStoreStaleQueryThreshold | |
| QuotedIdentifierOn | Specifies the QUOTED_IDENTIFIER database option. |
| ReadOnly | Specifies the READ_ONLY | READ_WRITE database option. |
| RecoveryMode | Specifies the RECOVERY database option. |
| RecursiveTriggersOn | Specifies the RECURSIVE_TRIGGERS database option. |
| ServiceBrokerOption | Specifies the ENABLE_BROKER | DISABLE_BROKER | NEW_BROKER | ERROR_BROKER_CONVERSATIONS database option. |
| StorageType | Specifies the storage type - in memory or file backed. Default value is Memory |
| SupplementalLoggingOn | Specifies the SUPPLEMENTAL_LOGGING database option. |
| TargetRecoveryTimePeriod | Specifies the period of the TARGET_RECOVERY_TIME database option. |
| TargetRecoveryTimeUnit | Specifies the unit of the TARGET_RECOVERY_TIME database option. |
| TornPageProtectionOn | Specifies the TORN_PAGE_DETECTION database option. |
| TransactionIsolationReadCommittedSnapshot | Specifies the READ_COMMITTED_SNAPSHOT database option. |
| TransformNoiseWords | Specifies the TRANSFORM_NOISE_WORDS database option. |
| Trustworthy | Specifies the TRUSTWORTHY database option. |
| TwoDigitYearCutoff | Specifies the TWO_DIGIT_YEAR_CUTOFF database option. |
| UserAccessOption | Specifies the SINGLE_USER | RESTRICTED_USER | MULTI_USER database option. |
| VardecimalStorageFormatOn | Specifies the sp_db_vardecimal_storage_format database option. |
| WithEncryption | Specifies the ENCRYPTION database option. |