Configuration value constants are returned by the ID property of the ConfigValue object, providing unique identification of a Microsoft® SQL Server™ configurable option, such as the resource time-out period.
For more information about setting options, see Setting Configuration Options.
In the table, the constant description is matched to content describing the option specified by the constant. For a description of the option and its maximum, minimum, and default running values, see the referenced content in SQL Server documentation.
| Constant | Value | Reference |
|---|---|---|
| SQLDMOConfig_AllowUpdates | 102 | allow updates Option |
| SQLDMOConfig_CostThresholdForParallelism | 1538 | cost threshold for parallelism Option |
| SQLDMOConfig_CursorThreshold | 1531 | cursor threshold Option |
| SQLDMOConfig_DefaultLanguage | 124 | default language Option |
| SQLDMOConfig_DefaultSortorderId | 1123 | Obsolete |
| SQLDMOConfig_FillFactor | 109 | fill factor Option |
| SQLDMOConfig_IndexCreateMem | 1505 | index create memory Option |
| SQLDMOConfig_LanguageInCache | 125 | Obsolete |
| SQLDMOConfig_LanguageNeutral | 1126 | default full-text language Option |
| SQLDMOConfig_LightweightPooling | 1546 | lightweight pooling Option |
| SQLDMOConfig_Locks | 106 | locks Option |
| SQLDMOConfig_MaxAsyncIO | 502 | Obsolete |
| SQLDMOConfig_MaxDegreeOfParallelism | 1539 | max degree of parallelism Option |
| SQLDMOConfig_MaxMemory | 1544 | Server Memory Options |
| SQLDMOConfig_MaxTextReplSize | 1536 | max text repl size Option |
| SQLDMOConfig_MaxWorkerThreads | 503 | max worker threads Option |
| SQLDMOConfig_MediaRetention | 1537 | media retention Option |
| SQLDMOConfig_MinMemoryPerQuery | 1540 | min memory per query Option |
| SQLDMOConfig_MinMemory | 1543 | Server Memory Options |
| SQLDMOConfig_NestedTriggers | 115 | nested triggers Option |
| SQLDMOConfig_NetworkPacketSize | 505 | network packet size Option |
| SQLDMOConfig_OpenObjects | 107 | open objects Option |
| SQLDMOConfig_PriorityBoost | 1517 | priority boost Option |
| SQLDMOConfig_ProcessorAffinityMask | 1535 | affinity mask Option |
| SQLDMOConfig_QueryMaxTime | 1545 | query governor cost limit Option |
| SQLDMOConfig_QueryWait | 1541 | query wait Option |
| SQLDMOConfig_RecoveryInterval | 101 | recovery interval Option |
| SQLDMOConfig_RemoteAccess | 117 | remote access Option |
| SQLDMOConfig_RemoteConnTimeout | 543 | Obsolete |
| SQLDMOConfig_RemoteLoginTimeout | 1519 | remote login timeout Option |
| SQLDMOConfig_RemoteProcTrans | 542 | remote proc trans Option |
| SQLDMOConfig_RemoteQueryTimeout | 1520 | remote query timeout Option |
| SQLDMOConfig_ResourceTimeout | 1533 | Obsolete |
| SQLDMOConfig_SetWorkingSetSize | 1532 | set working set size Option |
| SQLDMOConfig_ShowAdvancedOption | 518 | show advanced options Option |
| SQLDMOConfig_SpinCounter | 1514 | Obsolete |
| SQLDMOConfig_TimeSlice | 1110 | Obsolete |
| SQLDMOConfig_TwoDigitYearCutoff | 1127 | two digit year cutoff Option |
| SQLDMOConfig_UnicodeComparisonStyle | 1125 | Obsolete |
| SQLDMOConfig_UnicodeLocalID | 1124 | Obsolete |
| SQLDMOConfig_UserConnections | 103 | user connections Option |
| SQLDMOConfig_UserOptions | 1534 | user options Option |
| SQLDMOConfig_VLMSize | 1542 | Obsolete |