title: How do I temporarily suppress error Messages in SSMS?
body: <p>The following command attempts to reseed the identity value for all tables in the current database.</p>
  
  <pre><code>exec sp_MSforeachtable @command1 = 'DBCC CHECKIDENT(''?'', RESEED, 1)'
  </code></pre>
  
  <p>An error message is generated for each table that does not have an identity column.</p>
  
  <blockquote>
    <p>Msg 7997, Level 16, State 1, Line 1    'MyTable' does not contain an identity column.</p>
  </blockquote>
  
  <p><strong>I would like to suppress all error messages for this single line of code above, but not suppress them for the rest of the code in the SQL file.</strong></p>
  
  <p>Any ideas?</p>