Management Studio: Omit "Set" when modifying a proc

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: DWalker07 <none@xxxxxxxx>
Date: Thu, 15 Jan 2009 12:46:21 -0800

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
.

Follow-Ups:
- Re: Management Studio: Omit "Set" when modifying a proc
  - From: Erland Sommarskog

Prev by Date: Re: SQL Maintenance Plans and Atomic Backups of a Set of Databases
Next by Date: Re: SQL Maintenance Plans and Atomic Backups of a Set of Databases
Previous by thread: SQL Maintenance Plans and Atomic Backups of a Set of Databases
Next by thread: Re: Management Studio: Omit "Set" when modifying a proc
Index(es):
- Date
- Thread

Relevant Pages

.net updates errors
... I also had error messages and downloaded files to remove previous beta versions, removing earlier .Net Versions in Control Panel, clean up utility etc... ... i keep getting lately the same updates notifications about the next .net ... anything of the .net framework (using the add/remove window and then the MS ...
(microsoft.public.windowsupdate)
.net updates errors
... I also had error messages and downloaded files to remove previous beta versions, removing earlier .Net Versions in Control Panel, clean up utility etc... ... i keep getting lately the same updates notifications about the next .net ... anything of the .net framework (using the add/remove window and then the MS ...
(microsoft.public.windowsupdate)
.net updates errors
... I also had error messages and downloaded files to remove previous beta versions, removing earlier .Net Versions in Control Panel, clean up utility etc... ... i keep getting lately the same updates notifications about the next .net ... anything of the .net framework (using the add/remove window and then the MS ...
(microsoft.public.windowsupdate)
Re: Delphi 2007 Installation Problems
... I followed your instructions on removing and re-installing help, ... error messages in there? ...
(borland.public.delphi.non-technical)
Re: mdwtools syntax package
... output, but not for PDF, removing this resolved the error messages. ... my understanding is that the grammar gets nicely aligned on ...
(comp.text.tex)