Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |