As of version 5.6, the Isah database uses new values for the folowing database settings:

• ANSI NULLS Enabled
• ANSI Padding Enabled
• Arithmetic Abort Enabled
• Quoted Identifiers Enabled
• ANSI NULL Default
• Concatenate Null Yields Null.

When patching the Isah database to version 5.6 (or higher), these settings will be automatically configured to have the correct values. However, before updating an Isah database to version 5.6 (or higher), the ANSI migration script must be executed once for that database so that all database objects are created with the correct ANSI Settings.

Customization SQL code needs to be checked and converted to work correctly with the new ANSI settings. Tools and procedures have been developed to make this task as easy as possible. Please contact Isah or your Isah partner before this task needs to be carried out.

SQL Server itself also has some ANSI settings to configure the default connection options. It is not required to change these default connection options on the SQL Server level for the Isah applications to work with the correct ANSI Settings.