ANSI_DEFAULTS Setting in Access and SQL Server

In Microsoft® SQL Server™, when ANSI_DEFAULTS is set ON, these ANSI standards are activated:

• ANSI_NULLS
• ANSI_NULL_DFLT_ON
• CURSOR_CLOSE_ON_COMMIT
• ANSI_PADDING
• IMPLICIT_TRANSACTIONS
• ANSI_WARNINGS
• QUOTED_IDENTIFIER

Queries written by Microsoft Access adhere to these standards. To maintain consistent behavior in queries after they have been migrated from Access to SQL Server, you may want to ensure that ANSI_DEFAULTS is set ON.

See Also

SET ANSI_DEFAULTS