Supported SQL Server Configuration Options
Go Up to Parameters, Arguments, Options, and Variables Appendix
The following options are available from the Explorer’s Configuration node. For information on working with these options, see Working with Configuration/initialization Parameters.
access check cache bucket count |
access check cache quota |
Ad Hoc Distributed Queries |
affinity I/O mask |
affinity mask |
Agent XPs |
allow updates |
awe enabled |
backup compression default |
blocked process threshold |
c2 audit mode |
clr enabled |
common criteria compliance enabled |
cost threshold for parallelism |
cross db ownership chaining |
cursor threshold |
Database Mail XPs 0 0 0 1 Yes |
default full-text language |
default language |
default trace enabled |
disallow results from triggers |
EKM provider enabled |
filestream access level |
fill factor (%) |
ft crawl bandwidth (max) |
ft crawl bandwidth (min) |
ft notify bandwidth (max) |
ft notify bandwidth (min) |
index create memory (KB) |
in-doubt xact resolution |
lightweight pooling 0 0 0 1 No |
locks 0 0 5000 2147483647 No |
max degree of parallelism |
max full-text crawl range |
max server memory (MB) |
max text repl size (B) |
max worker threads |
media retention |
min memory per query (KB) |
min server memory (MB |
nested triggers |
network packet size (B) |
Ole Automation Procedures |
open objects |
optimize for ad hoc workloads |
PH timeout (s) |
precompute rank |
priority boost |
query governor cost limit |
query wait (s) |
recovery interval (min) |
remote access |
remote admin connections |
remote login timeout (s) |
remote proc trans |
remote query timeout (s) |
Replication XPs |
scan for startup procs |
server trigger recursion |
set working set size |
show advanced options |
SMO and DMO XPs |
SQL Mail XPs 0 0 0 1 |
transform noise words 0 0 0 1 |
two digit year cutoff |
user connections |
user options |
xp_cmdshell |