title: How to detect if a stored procedure already exists
body: <p>I have to write a deployment script which will work if a stored procedure exists or does not exist.   i.e. if it exists, then I need to alter it, otherwise create it.</p>
  
  <p>How can I do this in the sql.</p>
  
  <p>I am using SQL Server 2005</p>