Keywords for server options

Table 2-38 lists the keywords for configuring the server options for a connection.

Application calls to ct_options always override equivalent settings in the configuration file.

The keywords for setting server options are listed in Table 2-38. For descriptions of what each option controls, see “Options”.

**Table 2-38: Configuration file keywords for server options**
Keyword	Legal value
CS_OPT_ANSINULL	CS_TRUE or CS_FALSE
CS_OPT_ANSIPERM	CS_TRUE or CS_FALSE
CS_OPT_ARITHABORT	CS_TRUE or CS_FALSE
CS_OPT_ARITHIGNORE	CS_TRUE or CS_FALSE
CS_OPT_AUTHOFF	A string value
CS_OPT_AUTHON	A string value
CS_OPT_CHAINXACTS	CS_TRUE or CS_FALSE
CS_OPT_CURCLOSEONXACT	CS_TRUE or CS_FALSE
CS_OPT_CURREAD	A string value.
CS_OPT_CURWRITE	A string value
CS_OPT_DATEFIRST	CS_OPT_SUNDAY, CS_OPT_MONDAY, CS_OPT_TUESDAY, CS_OPT_WEDNESDAY, CS_OPT_THURSDAY, CS_OPT_FRIDAY, or CS_OPT_SATURDAY
CS_OPT_DATEFORMAT	CS_OPT_FMTMDY, CS_OPT_FMTDMY, CS_OPT_FMTYMD, CS_OPT_FMTYDM, CS_OPT_FMTMYD, or CS_OPT_FMTDYM
CS_OPT_FIPSFLAG	CS_TRUE or CS_FALSE
CS_OPT_FORCEPLAN	CS_TRUE or CS_FALSE
CS_OPT_FORMATONLY	CS_TRUE or CS_FALSE
CS_OPT_GETDATA	CS_TRUE or CS_FALSE
CS_OPT_IDENTITYOFF	A string value
CS_OPT_IDENTITYON	A string value
CS_OPT_ISOLATION	CS_OPT_LEVEL0, CS_OPT_LEVEL1, or CS_OPT_LEVEL3
CS_OPT_NOCOUNT	CS_TRUE or CS_FALSE
CS_OPT_NOEXEC	CS_TRUE or CS_FALSE
CS_OPT_PARSEONLY	CS_TRUE or CS_FALSE
CS_OPT_QUOTED_IDENT	CS_TRUE or CS_FALSE
CS_OPT_RESTREES	CS_TRUE or CS_FALSE
CS_OPT_ROWCOUNT	An integer value
CS_OPT_SHOWPLAN	CS_TRUE or CS_FALSE
CS_OPT_SORTMERGE	CS_TRUE or CS_FALSE
CS_OPT_STATS_IO	CS_TRUE or CS_FALSE
CS_OPT_STATS_TIME	CS_TRUE or CS_FALSE
CS_OPT_TEXTSIZE	An integer value
CS_OPT_TRUNCIGNORE	CS_TRUE or CS_FALSE