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: Sql Script, Store procedures
Comments are closed.