title: How to find what caused errors reported in a SQL Server profiler trace?
body: <p>I was running a trace on a Sql Server 2005 using the profiler and need to find out what is causing the reported errors.</p>
  
  <p>I used the "blank" template, and selected all columns of the following events:</p>
  
  <ul>
  <li>Exception</li>
  <li>Exchange Spill Event</li>
  <li>Execution Warnings</li>
  <li>Hash Warnings</li>
  <li>Missing Column Statistics</li>
  <li>Missing Join Predicate</li>
  </ul>
  
  <p>I noticed a number of these errors in the "TextData" column:</p>
  
  <ul>
  <li>Error: 156, Severity: 16, State: 0</li>
  <li>Error: 208, Severity: 16, State: 0</li>
  </ul>
  
  <p>I looked up the errors (Incorrect syntax, Invalid object name), but how can I tell what stored procedure or query is causing them?</p>