title: way to retrieve the objects QUOTED_IDENTIFIER (and associated ANSI) settings?
body: <p>is there a way to identify whether the object is created with SET QUOTED_IDENTIFIER on or off?? (not only this set option, am lookin for a script to identify all the ANSI settings associated to the object)</p>
  
  <p>this is a follow up to the questions in staack <a href="https://stackoverflow.com/questions/1137821/problem-with-set-quoted-identifier">link - 1</a> and <a href="https://stackoverflow.com/questions/1243991/update-failed-because-the-following-set-options-have-incorrect-settings-quoted/1244326#1244326">Link-2</a></p>
  
  <p>i ve been getting the SET QUOTED_IDENTIFIER  error  on a single table (which got indexed view). I have verified all the settings, scripts are fine. and it created perfectly with correct settings. </p>
  
  <p>It gives the error all of a sudden after applying some db fixes (not our script)..</p>
  
  <p><strong>Note</strong>: sorry to open a new thread, i dint get any possible solution to my first <a href="https://stackoverflow.com/questions/1137821/problem-with-set-quoted-identifier">link - 1</a> thread, thought its dead</p>