9 august 2012 23:20
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?
10 august 2012 08:30ModeratorTools, Options, SQL Server Object Explorer, Scripting, Check for object existence. Set this to false to get the old behaviour.
- Marcat ca răspuns de Owen37 10 august 2012 14:35
10 august 2012 14:36
Who would have thought that checking for object existence would completely change the script generated...?