Monday, July 13, 2020
Beetle Blog
SQL Server INSERT/UPDATE Fails because of SET options
By: douglas - Sql Server - 2/28/2014 12:26:25 PM

 Exception Message:

INSERT 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.
In this case it is possible one of your stored procedures has SET ANSI_NULLS OFF.  Change it to "ON".

Last Modified: 2/28/2014 12:26:25 PM

Beetle Blog v0.2.2

Copyright © 1997 - 2020 All rights reserved.