My brain seems to be freezing on DB related situations, any way I forgot how to check for the existence of a stored procedure before dropping it. I will be able to find the information quickly now!

IF EXISTS (select * from syscomments where id = object_id ('dbo.SPROC_NAME'))
BEGIN    
    DROP PROCEDURE dbo.SPROC_NAME
END

Technorati tags: ,