SET QUOTED_IDENTIFIER OFF in Stored procedure generates error

• benkraiemchedlia

  SSCommitted

  Points: 1672

  More actions

  March 17, 2017 at 4:45 am

  #335744

  Hi, 

  I have a stored procedure with :  SET QUOTED_IDENTIFIER OFF, when I execute my code I have the following error :

  SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. 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.
  
  The same code works if I remove the stored porcedure.
  I tried to  SET QUOTED_IDENTIFIER ON after the execution of the stored procedure,  but I have the same error message.

  What should I do please ?

• benkraiemchedlia

  SSCommitted

  Points: 1672

  More actions

  March 17, 2017 at 5:06 am

  #1933716

  I tried a workaround, instead of using double quotes, I use simple quotes and I remove the  SET QUOTED_IDENTIFIER ...