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
Link to this page: //www.vb-net.com/sql/access/database.htm
<Return>  <SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <CHAT ME>  <ABOUT ME>  < THANKS ME>