Typically, the Scripter has to use Dynamic SQL like this when the "Include IF NOT EXISTS" option is set.
Turn that off and you should see hardly any dynamic SQL in your scripts.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]