If you right click on a single stored proc and script out a drop statement for it, the IF EXISTS is generated as part of the DROP. This has always been the case in all prior versions of SQL Server scripting tools. I'm just wondering where this feature went for 2005 and 2008 as well... If I use IF NOT EXISTS this option generates the IF EXISTS code for the DROP statement (which is what I'm looking for) however it puts the whole CREATE statement inside an EXEC dbo.sp_executesql clause, which I don't want.

Regards,

CVM