title: DROP PROCEDURE/CREATE PROCEDURE in TRY/CATCH block
body: <p>In SQL Server 2008 and above, if I am altering a stored procedure, I can issue a</p>
  
  <pre><code>DROP PROCEDURE foo IF EXISTS
  </code></pre>
  
  <p>command. If the procedure exists then it is dropped and if it doesn't exist then no error is thrown and processing continues. Is it worth wrapping the DROP PROCEDURE/CREATE PROCEDURE combination (when I am updating the code) in a TRY/CATCH block "just in case" or does the DROP PROCEDURE not return an error if something blocks it from the dropping the procedure?</p>