When I right-click on a proc and select "Modify", or select "Script Stored
Procedure As/Alter To/whatever", the Alter statement is preceded by:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

During development, in order for the line numbers to match what I see in
error messages, I am always removing these statements.

*How can I tell Management Studio that I don't want these statement in
front of the Alter Procedure statement?*

I have looked in Tools/Options/Scripting, but nothing seems to affect what
happens. I have these two things set ON in the instance properties, and in
the database properties.

Thanks for any help.


David Walker