Re: Edit/Modify Stored Procedure in Management Console 2005

Jim Little (123@xxxxxxxxx) writes:
I think you and I are basically on the same page... I stand by what I
said, though, regarding other programming environments (and I have over
20 years of professional experience to back-up this observation): a
document may need to be compiled in some environments, but no user
interface I know of presents you with an edit window and then requires
you to click an "Execute" button in order to "Save". You ALWAYS save the
document, and the environment takes care of "executing" it.

No, you don't always save the document. For instance, in Enterprise Manager
you don't have the option of saving the document at all. You can compile
it. Then to change it, you have to request a disassembly, so that you can
modify again.

The paradigm you see in Mgmt Studio is nothing new. It's the paradigm that
I worked with ever since I started to work with SQL Server 10 years ago.
That is the way ISQL/W and Enterprise Manager in the 6.5 tools worked. That
is how Query Analyzer in SQL 7 and SQL 2000 worked. The odd one out in all
categories is Enterprise Manager.

You've been working far too long with a flawed tool that has lead your
mind astray.

True, there is still things that are different in Mgmt Studio compared
to other environments. Modify is still disassembly. And there is no
"compile-and-save" option, that is, you cannot save the file do disk
everytime you change it. This is one of the reasons I prefer to use an
external editor (Textpad) for writing SQL code.

But it is not strange that SSMS works it way it does: what you have is
a general query window in which you can run all sorts of commands, not
just creating stored procedure. And in such environment Execute is a very
natural thing.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.