Instance Options

The following table provides an alphabetical list of instance options and corresponding database and SET options that are supported in Microsoft SQL Server 2005. For more information, see Setting Server Configuration Options.

Server option	SET option	Database option	Default setting
affinity mask Option	None	None	0
allow updates Option	None	None	0
awe enabled Option	None	None	0
C2 Audit Mode Option	None	None	0
cost threshold for parallelism Option	None	None	5
cursor threshold Option	None	None	-1
default full-text language Option	None	None	1033
default language Option	None	None	0
fill factor Option	None	None	0
index create memory Option	None	None	0
lightweight pooling Option	None	None	0
locks Option	None	None	0
max degree of parallelism Option	None	None	0
Server Memory Options	None	None	2147483647
max text repl size Option	None	None	65536
max worker threads Option	None	None	255
media retention Option	None	None	0
min memory per query Option	None	None	1024
Server Memory Options	None	None	0
nested triggers Option	None	None	1
network packet size Option	None	None	4096
priority boost Option	None	None	0
query governor cost limit Option	QUERY_GOVERNOR_COST_LIMIT	None	0
query wait Option	None	None	-1
recovery interval Option	None	None	0
remote access Option	None	None	1
remote login timeout Option	None	None	20
remote proc trans Option	None	None	0
remote query timeout Option	None	None	600
scan for startup procs Option	None	None	0
show advanced options Option	None	None	0
two digit year cutoff Option	None	None	2049
user connections Option	None	None	0
user options Option	ANSI_NULL_DFLT_ON ANSI_NULL_DFLT_OFF	ANSI_NULL_DEFAULT	OFF
	ANSI_NULLS	ANSI_NULLS	OFF
	ANSI_PADDING	ANSI_PADDING	ON
	ANSI_WARNINGS	ANSI_WARNINGS	OFF
	CURSOR_CLOSE_ON_COMMIT	CURSOR_CLOSE_ON_COMMIT	OFF
	IMPLICIT_TRANSACTIONS	None	OFF
	QUOTED_IDENTIFIER	QUOTED_IDENTIFIER	OFF
	ARITHABORT	ARITHABORT	OFF
	ARITHIGNORE	None	OFF
	DISABLE_DEF_CNST_CHK	None	OFF
	NOCOUNT	None	OFF

See Also

Concepts

Using Options in SQL Server

Help and Information

Getting SQL Server 2005 Assistance