title: UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
body: <p>I am having a problem with an update stored procedure. The error is:</p>
  
  <blockquote>
    <p>UPDATE 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 query notifications and/or xml data type methods.</p>
    
    <p>SQL State: 42000<br>
    Native Error: 1934</p>
  </blockquote>
  
  <p>Unfortunately, there are <strong>no</strong> indexed views, computed columns, or query notifications for this table. This Stored Procedure was running fine for past couple of days and since today has been returning this error.</p>
  
  <p>Is there any suggestion that would help in identifying the problem?</p>
  
  <p><strong>Note:</strong> If I set the <code>quoted_identifier</code> to <code>ON</code> and rerun the <code>CREATE PROCEDURE</code>, the issue will be fixed (for now). But I want to understand what triggered this issue in the first place.</p>