title: SQL Server Alert on Missing Stored Procedure
body: <p>I’m cleaning out a large database and am going to be removing a lot of stored procedures. I can be pretty certain but not 100% that the SP isn’t being used. How can I be alerted that something is calling a missing stored procedure, and throwing the error:</p>
  <pre><code>Could not find stored procedure ‘X’
  </code></pre>