Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Stop SSMS from scripting SPs using sp_executesql?

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

like image 695
Tony_Henrich Avatar asked Aug 11 '09 23:08

Tony_Henrich


1 Answers

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).

like image 101
RBarryYoung Avatar answered Oct 13 '22 02:10

RBarryYoung