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 |
|---|---|---|---|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
5 |
|
None |
None |
-1 |
|
None |
None |
1033 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
2147483647 |
|
None |
None |
65536 |
|
None |
None |
255 |
|
None |
None |
0 |
|
None |
None |
1024 |
|
None |
None |
0 |
|
None |
None |
1 |
|
None |
None |
4096 |
|
None |
None |
0 |
|
QUERY_GOVERNOR_COST_LIMIT |
None |
0 |
|
None |
None |
-1 |
|
None |
None |
0 |
|
None |
None |
1 |
|
None |
None |
20 |
|
None |
None |
0 |
|
None |
None |
600 |
|
None |
None |
0 |
|
None |
None |
0 |
|
None |
None |
2049 |
|
None |
None |
0 |
|
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 |