title: Automatically Drop Old Stored Procedure in SQL Server
body: <p>I'm writing a stored procedure in SQL Server 2008, interatively.  When using SQL Server Management Studio, every very time I make an update I have to manually refresh the Programmability folder, then right-click, then delete, then OK.  I could also run a query to drop the stored procedure as well.</p>
  
  <p>Is there some function I can drop into stored procedure when first executing the code (from the actual stored procedure code, not the exec command) that will check to see if there is an existing stored procedure, if so, then <code>DROP</code> and replace with the new code? </p>
  
  <p>Or, is this a bad idea due to version control?</p>