Check for existence of Stored Proc 1

[monkeylizard]

I'm creating a routine where I need to drop a Stored Procedure. I only want the command to execute if the SP exists to avoid any failures.

How can I get this information to know if the SP exists or not?

SQL 2005
Thanks in advance.

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

 

[SQLDenis]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ProcName]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ProcName]
GO

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com
Google Interview Questions

 

[monksnake]

I like the name monkeylizard.



<.

 

[monkeylizard]

Thanks SQLDenis. Have a star!

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.