I've been running 2008 SSMS locally for quite some time now ... and I think it was post CU2 install that I started having this problem. Anytime I right click a procedure and choose modify and/or script to create/drop/alter, it's wrapping the object in dynamic SQL!?
For example, right click "BackupDB" (procedure) -> modify =
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BackUpDB]') AND type in (N'P', N'PC'))
EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE [dbo].[BackUpDB]
Do the same in 2005 SSMS ...
ALTER PROCEDURE [dbo].[BackUpDB]
I tried removing the "Include IF NOT EXISTS clause" under scripting options and it did not change.
Thoughts, comments, suggestions?
Making SQL do what we want it to do.