title: SET QUOTED IDENTIFIER should be ON when inserting a record
body: <p>I am stuck in a rather strange problem with SQL Server 2005, which throws </p>
  
  <blockquote>
    <p>"SET QUOTED IDENTIFIER should be on when inserting record" </p>
  </blockquote>
  
  <p>(using as SP) to the particular table. This worked fine earlier but is throwing this error randomly.</p>
  
  <p>I have verified the SP. We didn't manually specify SET QUOTED IDENTIFIER settings inside, so it must be ON by default.</p>
  
  <p>Can someone clarify what could be the problem?</p>
  
  <p>The table must be created with SET QUOTED IDENTIFIER ON right? I didn't check the table script yet.</p>
  
  <p>I have observed that this problem only occur with the SPs doing insert or update on a date column (modifiedAt)... A sample value is '2009-08-10 06:43:59:447'..</p>
  
  <p>Is there a problem with the values passed?</p>