Re: Management Studio: Omit "Set" when modifying a proc

#1

DWalker07 (none (AT) none (DOT) com) writes:

Quote:

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?*

You keep your code under version control, and when you need to change a
file, you check it out and retrieve it from the version-control system.
The database is just a place where you have the binaries. You don't
version control your C# code by disassembling the DLLs, do you?

To go back to Mgmt Studio, I would suggest that you raise the issue on
http://connect.microsoft.com/sqlserver/feedback.

I can agree that seeing many of those can be too much by time. But at
least, they are no longer adding SET OFF commands at the end of the
script. (Except for ANSI_PADDING, but ANSI_PADDING you can off.)

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Management Studio: Omit "Set" when modifying a proc

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: Management Studio: Omit "Set" when modifying a proc - 01-15-2009 , 05:07 PM