SELECT INTO 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 filtered indexes and/or query notifications and/or XML

Question

Hi

I am facing this issue while calling one proc into other and aslo i used a index veiw

SELECT INTO 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 filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Plz help

Answer 1

Hi,

Can you give exact query

Answer 2

The error message is very clear.  The ansi_warnings setting must be on to execute your logic.  It is off, so you need to review the procedures to understand the cause and to find a solution.  

Answer 3

thanks