SET Options


SET option
Database option Server option Default setting
ANSI_DEFAULTS None None n/a
ANSI_NULL_DFLT_OFF
ANSI_NULL_DFLT_ON
ANSI null default user options assigns a default OFF
ANSI_NULLS ANSI nulls user options assigns a default OFF
ANSI_PADDING None user options assigns a default ON 
ANSI_WARNINGS ANSI warnings user options assigns a default OFF
ARITHABORT None user options assigns a default OFF
ARITHIGNORE None user options assigns a default OFF
CONCAT_NULL_YIELDS_NULL concat null yields null None OFF
CONTEXT_INFO None None OFF
CURSOR_CLOSE_ON_COMMIT cursor close on commit user options assigns a default OFF
DATEFIRST None None 7
DATEFORMAT None None mdy
DEADLOCK_PRIORITY None None NORMAL
DISABLE_DEF_CNST_CHK None user options assigns a default OFF
FIPS_FLAGGER None None OFF
FMTONLY None None OFF
SET FORCEPLAN None None OFF
IDENTITY_INSERT None   OFF
IMPLICIT_TRANSACTIONS None user options assigns a default OFF
LANGUAGE None None us_english
LOCK_TIMEOUT None None No limit
NOCOUNT None user options assigns a default OFF
NOEXEC None None OFF
NUMERIC_ROUNDABORT None None OFF
OFFSETS None None OFF
PARSEONLY None None OFF
QUERY_GOVERNOR_COST_LIMIT None query governor cost limit OFF
QUOTED_IDENTIFIER quoted identifier user options assigns a default OFF
REMOTE_PROC_TRANSACTIONS None None OFF
ROWCOUNT None None OFF
SHOWPLAN_ALL None None OFF
SHOWPLAN_TEXT None None OFF
STATISTICS IO None None OFF
STATISTICS PROFILE None None n/a
STATISTICS TIME None None OFF
TEXTSIZE None None OFF
TRANSACTION ISOLATION LEVEL None None n/a
XACT_ABORT None 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
Link to this page: //www.vb-net.com/sql/access/set.htm
<Return>  <SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <CHAT ME>  <ABOUT ME>  < THANKS ME>