Share via


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