views:

202

answers:

2

When I use SSMS to script a stored procedure, it wraps the script in a sp_executesql statement which bugs me. Is there a way to stop SSMS from doing this and use a straight CREATE PROCEDURE...?

EDIT: I meant SSMS not SSIS

+1  A: 

Execute SQL Task Editor (General Page)

Look at the "QueryIsStoredProcedure" and "BypassPrepare" options

gbn
Sorry I meant SSMS
Tony_Henrich
Fair call. I also read "execute" not "script" too ;-)
gbn
+2  A: 

Turn off the "Include IF NOT EXISTS" option.

It's at Tools..Options, then click "Scripting" on the explorer pane of the dialog that pops-up. the "IF NOT EXISTS" option is in the second group from the top (Object Scripting options).

RBarryYoung