Server Options
Server option |
SET option |
Database option |
Default setting |
|---|---|---|---|
| affinity mask | None | None | 0 |
| allow updates | None | None | 0 |
| awe enabled | None | None | 0 |
| c2 audit mode | None | None | 0 |
| cost threshold for parallelism | None | None | 5 |
| cursor threshold | None | None | -1 |
| default full-text language | None | None | 1033 |
| default language | None | None | 0 |
| fill factor | None | None | 0 |
| index create memory | None | None | 0 |
| lightweight pooling | None | None | 0 |
| locks | None | None | 0 |
| max degree of parallelism | None | None | 0 |
| max server memory | None | None | 2147483647 |
| max text repl size | None | None | 65536 |
| max worker threads | None | None | 255 |
| media retention | None | None | 0 |
| min memory per query | None | None | 1024 |
| min server memory | None | None | 0 |
| nested triggers | None | None | 1 |
| network packet size | None | None | 4096 |
| open objects | None | None | 0 |
| priority boost | None | None | 0 |
| query governor cost limit | QUERY_GOVERNOR_COST_ LIMIT |
None | 0 |
| query wait | None | None | -1 |
| recovery interval | None | None | 0 |
| remote access | None | None | 1 |
| remote login timeout | None | None | 20 |
| remote proc trans | None | None | 0 |
| remote query timeout | None | None | 600 |
| scan for startup procs | None | None | 0 |
| set working set size | None | None | 0 |
| show advanced options | None | None | 0 |
| two digit year cutoff | None | None | 2049 |
| user connections | None | None | 0 |
| user options | ANSI_NULL_DFLT_ON ANSI_NULL_DFLT_OFF |
ANSI null default | OFF |
| ANSI_NULLS | ANSI nulls | OFF | |
| ANSI_PADDING | None | 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 | None | OFF | |
| ARITHIGNORE | None | OFF | |
| DISABLE_DEF_CNST_CHK | None | OFF | |
| NOCOUNT | None | OFF |
Comments (
)
)
<00>
<01>
<02>
<03>
<04>
<05>
<06>
<07>
<08>
<09>
<10>
<11>
<12>
<13>
<14>
<15>
<16>
<17>
<18>
<19>
<20>
<21>
<22>
<23>
Link to this page:
//www.vb-net.com/sql/access/server.htm
| <SITEMAP> <MVC> <ASP> <NET> <DATA> <KIOSK> <FLEX> <SQL> <NOTES> <LINUX> <MONO> <FREEWARE> <DOCS> <ENG> <CHAT ME> <ABOUT ME> < THANKS ME> |