Assisted Editor for stored procedures

I have been using SQL server management studio beta to manage my SQL server 2000 and to develop stored procedures. I was very happy with Assisted Editor, but it seems to be missing from final SQL server 2005 products (developer's version) .

In object browser when I right-click on stored procedure and chose modify I used to get Assisted editor (described in http://msdn.microsoft.com/sql/learn/prog/tsql/default.aspx?pull=/library/en-us/dnsql90/html/tsqlqueries.asp). Now I get full Alter procedure statement (like in old Query analyzer) that can be edited and executed but not "real time" edited.

Is there any setting to get my beloved Assisted Editor back or Microsoft decided to get us rid of this user friendly addition?

Thanks and regards, Danko Jevtovic

The assisted editors functionality was cut from SQL Server 2005.

We had a lot of work left to make the feature correctly handle all the scenarios it needed to handle, and we ran out of time to fix it.

Assisted Editor

I have a book that refers to the "SQL Server Assisted Editor" in management
Studio. but when I right click on the Stored Procedure node or anything
else I can't get the Assisted Editor. Where is it?
Regards,
Gary Blakely
GaryDean (GaryDean@.newsgroups.nospam) writes:
> I have a book that refers to the "SQL Server Assisted Editor" in
> management Studio. but when I right click on the Stored Procedure node
> or anything else I can't get the Assisted Editor. Where is it?
It was in the betas of Mgmt Studio, but it was dropped along the way. In
my opinion, it was just as well, since it did really add that much. One
shortcoming as I recall was that you could only add a new parameter at
the end of the parameter lsit.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
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
|||Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:
Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).
If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:eEoY8jMFHHA.3776@.TK2MSFTNGP02.phx.gbl...
>I have a book that refers to the "SQL Server Assisted Editor" in management
>Studio. but when I right click on the Stored Procedure node or anything
>else I can't get the Assisted Editor. Where is it?
> --
> Regards,
> Gary Blakely
>
|||Hi Gary,
Please notice that I'v replied to the same issue in
microsoft.public.sqlserver.server newsgroup. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====