You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! Universal.NET > UPDATE failed because the following SET options have incorrect settings: 'ANSI_NULLS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
UPDATE failed because the following SET options have incorrect settings: 'ANSI_NULLS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
print icon

Module

ExpireUnusedCards

Symptoms

When the external mechanism responsible for deactivating unused cards runs at the top of the hour, the error "UPDATE failed because the following SET options have incorrect settings: 'ANSI_NULLS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations." is logged in the event log and no cards are deactivated.

Cause

The AIUniversal stored procedure 'ExpireCard' is incorrectly configured with the value ANSI_NULLS set to OFF.

Resolution

Using SQL Server Management Studio, modify the stored procedure ExpireCard and set the ANSI_NULLS flag to ON.


scroll to top icon