Check before you drop July 16, 2011 Check to see if a proc exists before dropping it if exists (select name from sysobjects where type = 'P' and name = 'XX') drop proc XX go Read more