title: What is the syntax to drop a Stored Procedure in SQL Server 2000?
body: <p>Simple question, as the title suggests:</p>
  
  <p>What is the syntax to drop a Stored Procedure (SP) in SQL Server 2000, by first checking that the SP exists?</p>
  
  <p>Please provide the full code.</p>