locked
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 RRS feed

  • 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

    Wednesday, March 13, 2013 7:15 PM

Answers

  • 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.  
    • Proposed as answer by Papy Normand Saturday, March 16, 2013 9:51 PM
    • Marked as answer by Iric Wen Thursday, March 21, 2013 9:22 AM
    Thursday, March 14, 2013 5:54 PM

All replies

  • Hi,

    Can you give exact query

    Thursday, March 14, 2013 4:39 AM
  • 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.  
    • Proposed as answer by Papy Normand Saturday, March 16, 2013 9:51 PM
    • Marked as answer by Iric Wen Thursday, March 21, 2013 9:22 AM
    Thursday, March 14, 2013 5:54 PM
  • thanks
    Tuesday, March 19, 2013 6:48 PM