'ANSI_WARNINGS' settings error during application install

Hello,


During the installation of an application, I receive the following error;


System.Data.SqlClient.SqlException: CONDITIONAL failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.

I believe this occurs during an INSERT or UPDATE to a table used by the application but am still verifying this.

Doe anyone have any suggestions on why this error would occur.
I have tried setting the ANSI_WARNINGS to 'True' which did not solve this error generation.


Thanks,


Charlie
Charlie_MelegaAsked:
Who is Participating?
 
paulwayCommented:
You want to toggle your ANSI_WARNINGS.  This is either OFF or ON.  By default, it is generally OFF.

Use sp_configure to determine what state it is currently in.  Then use sp_configure to toggle it.
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
You need to set ANSI_WARNINGS to ON for creating Indexed views:
just include this in your VIEW script.

SET ANSI_WARNINGS ON;
GO
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
In addition to the ANSI_WARNINGS settings, check out the other ANSI settings required for creating Indexed views:

http://msdn.microsoft.com/en-us/library/ms191432.aspx
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
angelIII,

I would recommend split between

http:#a31242123, http:#a31243278, http:#a31249897
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.