Transact-SQL Option Settings for Adaptive Server Enterprise Compatibility

The default setting for some options differs from the Adaptive Server Enterprise default setting. To ensure compatible behavior, you should explicitly set the options.

When a connection is made using the Open Client or JDBC interfaces, some option settings are explicitly set for the current connection to be compatible with Adaptive Server Enterprise.

Transact-SQL Options Set Explicitly for ASE Compatibility
Option	ASE-compatible setting
`ALLOW_NULLS_BY_DEFAULT`	OFF
`ANSINULL`	OFF
`CHAINED`	OFF
`CONTINUE_AFTER_RAISERROR`	ON
`DATE_FORMAT`	YYYY-MM-DD
`DATE_ORDER`	MDY
`ESCAPE_CHARACTER`	OFF
`ISOLATION_LEVEL`	1
`ON_TSQL_ERROR`	CONDITIONAL
`QUOTED_IDENTIFIER`	OFF
`TIME_FORMAT`	HH:NN:SS.SSS
`TIMESTAMP_FORMAT`	YYYY-MM-DD HH:NN:SS.SSS
`TSQL_VARIABLES`	OFF