title: Scope of SET ANSI_WARNINGS OFF
body: <p>if I have <code>SET ANSI_WARNINGS OFF</code> in one stored procedure to get rid of a warning, it only takes effects of that stored procedure and has no impact on other ones, which means in other stored procedures, the <code>ANSI_WARNINGS</code> is still on.
  What if I want to turn it off for all stored procedures?
  Why it is default on? How could I know that?</p>
  
  <p>Do other settings(e.g., <code>NOCOUNT</code>) in sql server work the same way?</p>
  
  <p>Thanks a lot.</p>
  
  <p>It will be great if anybody can share articles about common characteristics of these settings with me.</p>