Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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 |