Database Options
| Database option | SET option |
Server option |
Default setting |
|---|---|---|---|
| ANSI null default | ANSI_NULL_DFLT_ON ANSI_NULL_DFLT_OFF |
user options assigns a default | OFF |
| ANSI nulls | ANSI_NULLS | user options assigns a default | OFF |
| ANSI warnings | ANSI_WARNINGS | user options assigns a default | OFF |
| auto create statistics | None | None | ON |
| auto update statistics | None | None | ON |
| autoclose | None | None | FALSE1 |
| autoshrink | None | None | FALSE |
| concat null yields null | CONCAT_NULL_YIELDS_NULL | None | OFF |
| cursor close on commit | CURSOR_CLOSE_ON_COMMIT | user options assigns a default | OFF |
| dbo use only | None | None | FALSE |
| default to local cursor | None | None | FALSE |
| merge publish | None | None | FALSE |
| offline | None | None | FALSE |
| published | None | None | FALSE |
| quoted identifier | QUOTED_IDENTIFIER | user options assigns a default | OFF |
| read only | None | None | FALSE |
| recursive triggers | None | None | FALSE |
| select into/ bulkcopy | None | None | FALSE |
| single user | None | None | FALSE |
| subscribed | None | None | TRUE |
| torn page detection | None | TRUE | |
| trunc. log on chkpt. | None | None | TRUE |
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/database.htm
| <SITEMAP> <MVC> <ASP> <NET> <DATA> <KIOSK> <FLEX> <SQL> <NOTES> <LINUX> <MONO> <FREEWARE> <DOCS> <ENG> <CHAT ME> <ABOUT ME> < THANKS ME> |