General Database Options

General database options is the class of options consisting of all options except Transact-SQL compatibility options and Interactive SQL options.

Parent topic: Database Options
Related concepts
Transact-SQL Compatibility Options
Interactive SQL Options
Related reference
AFFINITY_AUTOEXCLUDE_TIMEOUT Option
AGGREGATION_PREFERENCE Option
ALLOW_SNAPSHOT_VERSIONING Option
ANSI_UPDATE_CONSTRAINTS Option
ALLOW_READ_CLIENT_FILE Option
ASE_BINARY_DISPLAY Option
ASE_FUNCTION_BEHAVIOR Option
AUDITING Option [database]
BASE_TABLES_IN_RLV_STORE Option
BIT_VECTOR_PINNABLE_CACHE_PERCENT Option
BLOCKING Option
BLOCKING_TIMEOUT Option
BT_PREFETCH_MAX_MISS Option
BT_PREFETCH_SIZE Option
BTREE_PAGE_SPLIT_PAD_PERCENT Option
CACHE_AFFINITY_PERCENT Option
CACHE_PARTITIONS Option
CHECKPOINT_TIME Option
CIS_ROWSET_SIZE Option
CONVERSION_MODE Option
CONVERT_VARCHAR_TO_1242 Option
COOPERATIVE_COMMIT_TIMEOUT Option
COOPERATIVE_COMMITS Option
CREATE_HG_WITH_EXACT_DISTINCTS
CURSOR_WINDOW_ROWS Option
DATE_FIRST_DAY_OF_WEEK Option
DATE_FORMAT Option
DATE_ORDER Option
DBCC_LOG_PROGRESS Option
DBCC_PINNABLE_CACHE_PERCENT Option
DEBUG_MESSAGES Option
DEDICATED_TASK Option
DEFAULT_DBSPACE Option
DEFAULT_DISK_STRIPING Option
DEFAULT_HAVING_SELECTIVITY_PPM Option
DEFAULT_KB_PER_STRIPE Option
DEFAULT_LIKE_MATCH_SELECTIVITY_PPM Option
DEFAULT_LIKE_RANGE_SELECTIVITY_PPM Option
DEFAULT_PROXY_TABLE_ROW_COUNT Option
DEFAULT_TABLE_UDF_ROW_COUNT Option
DELAYED_COMMIT_TIMEOUT Option
DELAYED_COMMITS Option
DISABLE_RI_CHECK Option
DQP_ENABLED Option
DQP_ENABLED_OVER_NETWORK Option
EARLY_PREDICATE_EXECUTION Option
ENABLE_ASYNC_IO Option
ENABLE_LOB_VARIABLES Option
EXTENDED_JOIN_SYNTAX Option
FLOATING_POINT_ACCUMULATOR Option
FORCE_DROP Option
FORCE_NO_SCROLL_CURSORS Option
FORCE_UPDATABLE_CURSORS Option
FP_LOOKUP_SIZE Option
FP_LOOKUP_SIZE_PPM Option
FP_NBIT_AUTOSIZE_LIMIT Option
FP_NBIT_ENFORCE_LIMITS Option
FP_NBIT_IQ15_COMPATIBILITY Option
FP_NBIT_LOOKUP_MB Option
FP_NBIT_ROLLOVER_MAX_MB Option
FP_PREDICATE_WORKUNIT_PAGES Option
FPL_EXPRESSION_MEMORY_KB Option
GARRAY_FILL_FACTOR_PERCENT Option
GARRAY_INSERT_PREFETCH_SIZE Option
GARRAY_PAGE_SPLIT_PAD_PERCENT Option
GARRAY_RO_PREFETCH_SIZE Option
HASH_PINNABLE_CACHE_PERCENT Option
HASH_THRASHING_PERCENT Option
HG_DELETE_METHOD Option
HG_SEARCH_RANGE Option
HTTP_SESSION_TIMEOUT Option
IDENTITY_ENFORCE_UNIQUENESS Option
IDENTITY_INSERT Option
IN_SUBQUERY_PREFERENCE Option
INDEX_ADVISOR Option
INDEX_ADVISOR_MAX_ROWS Option
INDEX_PREFERENCE Option
INFER_SUBQUERY_PREDICATES Option
IQGOVERN_MAX_PRIORITY Option
IQGOVERN_PRIORITY Option
IQGOVERN_PRIORITY_TIME Option
ISOLATION_LEVEL Option
JAVA_LOCATION Option
JAVA_VM_OPTIONS Option
JOIN_EXPANSION_FACTOR Option
JOIN_OPTIMIZATION Option
JOIN_PREFERENCE Option
JOIN_SIMPLIFICATION_THRESHOLD Option
LF_BITMAP_CACHE_KB Option
LOAD_ZEROLENGTH_ASNULL Option
LOG_CONNECT Option
LOG_CURSOR_OPERATIONS Option
LOG_DEADLOCKS Option
LOGIN_MODE Option
LOGIN_PROCEDURE Option
MAIN_RESERVED_DBSPACE_MB Option
MAX_CARTESIAN_RESULT Option
MAX_CLIENT_NUMERIC_PRECISION Option
MAX_CLIENT_NUMERIC_SCALE Option
MAX_CUBE_RESULT Option
MAX_CURSOR_COUNT Option
MAX_HASH_ROWS Option
MAX_IQ_THREADS_PER_CONNECTION Option
MAX_IQ_THREADS_PER_TEAM Option
MAX_JOIN_ENUMERATION Option
MAX_PARTITIONED_HASH_MB Option
MAX_PREFIX_PER_CONTAINS_PHRASE Option
MAX_QUERY_PARALLELISM Option
MAX_QUERY_TIME Option
MAX_STATEMENT_COUNT Option
MAX_TEMP_SPACE_PER_CONNECTION Option
MINIMIZE_STORAGE Option
MIN_PASSWORD_LENGTH Option
MIN_ROLE_ADMINS Option
MONITOR_OUTPUT_DIRECTORY Option
MPX_AUTOEXCLUDE_TIMEOUT Option
MPX_HEARTBEAT_FREQUENCY Option
MPX_IDLE_CONNECTION_TIMEOUT Option
MPX_LIVENESS_TIMEOUT Option
MPX_MAX_CONNECTION_POOL_SIZE Option
MPX_MAX_UNUSED_POOL_SIZE Option
MPX_WORK_UNIT_TIMEOUT Option
NOEXEC Option
NON_ANSI_NULL_VARCHAR Option
NOTIFY_MODULUS Option
ODBC_DISTINGUISH_CHAR_AND_VARCHAR Option
ON_CHARSET_CONVERSION_FAILURE Option
OS_FILE_CACHE_BUFFERING Option
OS_FILE_CACHE_BUFFERING_TEMPDB Option
POST_LOGIN_PROCEDURE Option
PRECISION Option
PREFETCH Option
PREFETCH_BUFFER_LIMIT Option
PREFETCH_BUFFER_PERCENT Option
PREFETCH_GARRAY_PERCENT Option
PREFETCH_SORT_PERCENT Option
PRESERVE_SOURCE_FORMAT Option [database]
QUERY_DETAIL Option
QUERY_NAME Option
QUERY_PLAN Option
QUERY_PLAN_AFTER_RUN Option
QUERY_PLAN_AS_HTML Option
QUERY_PLAN_AS_HTML_DIRECTORY Option
QUERY_PLAN_MIN_TIME Option
QUERY_PLAN_TEXT_ACCESS Option
QUERY_PLAN_TEXT_CACHING Option
QUERY_ROWS_RETURNED_LIMIT Option
QUERY_TEMP_SPACE_LIMIT Option
QUERY_TIMING Option
RECOVERY_TIME Option
RESERVED_KEYWORDS Option
RETURN_DATE_TIME_AS_STRING Option
REVERT_TO_V15_OPTIMIZER Option
ROUND_TO_EVEN Option
ROW_COUNT Option
RV_AUTO_MERGE_EVAL_INTERVAL Option
RV_MERGE_NODE_MEMSIZE Option
RV_MERGE_TABLE_MEMPERCENT Option
RV_MERGE_TABLE_NUMROWS Option
RV_RESERVED_DBSPACE_MB Option
SCALE Option
SNAPSHOT_VERSIONING Option
SIGNIFICANTDIGITSFORDOUBLEEQUALITY Option
SORT_COLLATION Option
SORT_PINNABLE_CACHE_PERCENT Option
SUBQUERY_CACHING_PREFERENCE Option
SUBQUERY_FLATTENING_PERCENT Option
SUBQUERY_FLATTENING_PREFERENCE Option
SUBQUERY_PLACEMENT_PREFERENCE Option
SUPPRESS_TDS_DEBUGGING Option
SWEEPER_THREADS_PERCENT Option
TDS_EMPTY_STRING_IS_NULL Option [database]
TEMP_EXTRACT_APPEND Option
TEMP_EXTRACT_BINARY Option
TEMP_EXTRACT_COLUMN_DELIMITER Option
TEMP_EXTRACT_DIRECTORY Option
TEMP_EXTRACT_ESCAPE_QUOTES Option
TEMP_EXTRACT_NAMEn Options
TEMP_EXTRACT_NULL_AS_EMPTY Option
TEMP_EXTRACT_NULL_AS_ZERO Option
TEMP_EXTRACT_QUOTE Option
TEMP_EXTRACT_QUOTES Option
TEMP_EXTRACT_QUOTES_ALL Option
TEMP_EXTRACT_ROW_DELIMITER Option
TEMP_EXTRACT_SIZEn Options
TEMP_EXTRACT_SWAP Option
TEMP_RESERVED_DBSPACE_MB Option
TEMP_SPACE_LIMIT_CHECK Option
TEXT_DELETE_METHOD Option
TIME_FORMAT Option
TIMESTAMP_FORMAT Option
TOP_NSORT_CUTOFF_PAGES Option
TRIM_PARTIAL_MBC Option
TRUSTED_CERTIFICATES_FILE Option
USER_RESOURCE_RESERVATION Option
VERIFY_PASSWORD_FUNCTION Option
WASH_AREA_BUFFERS_PERCENT Option
WAIT_FOR_COMMIT Option
WD_DELETE_METHOD Option