Supported SQL Server Configuration Options

Go Up to [[Parameters, Arguments, Options, and Variables Appendix{{#if:||{{{2}}}}}]]

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