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 (
)
)
Link to this page:
//www.vb-net.com/sql/access/database.htm
|
|