title: How do I suppress T-SQL warnings when running a script SQL Server 2005?
body: <p>Is it possible to suppress warnings generated by T-SQL scripts? If so, how?</p>
  
  <p>I know I can turn of the 'records affected' messages with</p>
  
  <pre><code>SET NOCOUNT ON
  </code></pre>
  
  <p>but is there an equivalent for warnings?
  Eg:</p>
  
  <pre><code>Warning: Null value is eliminated by an aggregate or other SET operation.
  </code></pre>
  
  <p>If I'm expecting these errors, it helps to sift the real errors from the chaff in a big script.</p>
  
  <p>Thanks.</p>