BeetleDev.com
info
contact
Saturday, December 15, 2018
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 - 2018 BeetleDev.com. All rights reserved.