title: Stop SQL Server Management Studio from adding ANSI_NULLS and QUOTED_IDENTIFIER
body: <p>How do I prevent SQL Management Studio (10.50.2500.0) from adding this to the beginning of every stored procedure when I right-click/Modify? </p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  </code></pre>
  
  <p>Neither of these settings are useful to me. ANSI_NULLS ON and QUOTED_IDENTIFIER ON is set on all my servers, DBs and connections I make. Besides that, I never use double quotes (I used brackets for reserved words) and all my nullable fields I properly use IS NULL when needed.</p>
  
  <p>I delete the settings every time I edit a procedure. All my procedures properly have them set and that will never change in my environment. Verified by:</p>
  
  <pre><code>SELECT uses_ansi_nulls, uses_quoted_identifier
  FROM sys.sql_modules
  WHERE object_id = object_id( 'proc_name' )
  </code></pre>