Management Studio Modify Stored Procedure options?

Question

I've changed some default setting somewhere and don't know what it was or how to get back.  It used to be, that when I right clicked on a stored procedure and selected Modify, it would come up with normal T-SQL commands with "ALTER PROCEDURE".  Now, however, it comes up with EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE...etc...' that is very confusing.  How do get rid of the EXEC to modify my stored procedures?  Where is the option?

Thanks,
Owen

Answer 1

Tools, Options, SQL Server Object Explorer, Scripting, Check for object existence. Set this to false to get the old behaviour.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 2

WOOT! Thanks! 

Who would have thought that checking for object existence would completely change the script generated...?