[dba-SQLServer] Viewing and Modifying stored procedures

Jennifer,

The query analyzer is not missing. It is what you would
get when you do the modify. Instead of being a different
program like the old days, it is built in.

What he is getting when he double clicks it in the old
version is the same thing he would get by right-clicking
and going to properties.

I am not sure what you mean by "it cannot be edited directly."
How much more directly can you get?

Of course you are going to use T-SQL to do the editing, that is
what it is written in. What were you expecting to use?  VBA?

I am a DBA and SQL Programmer. I much prefer the new interface
over the old one.  Stop fighting it and learn to use it. You do
not need Visual Studio for anything.  Unless you want to buy
the big build of it and get the "Database" version of it.  But,
even then you are not editing it directly like you would be
with management studio. I have it because of my MSDN subscription
and I tried it once and stopped using it.  It was way too cumbersome.


Robert

At 12:00 PM 6/27/2007, you wrote:
>Date: Tue, 26 Jun 2007 19:13:44 -0700
>From: "Jennifer Gross" <jengross at gte.net>
>Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <003901c7b860$ccfb7030$6501a8c0 at jefferson>
>Content-Type: text/plain; charset=us-ascii
>
>Hi Mark,
>
>That makes complete sense, but it doesn't work :(  I read somewhere that
>the Query Analyzer in previous versions of SQL Server is no longer a
>part of SQL Server 2005.  I am not sure, but have a feeling, that this
>missing Query Analyzer is the reason I can't do what I want to do.
>Apparently, unless you use T-SQL to edit stored procedures, the only
>other way they can be edited is through Visual Studio.  It can't be done
>directly in what is now called SQL Server Management Studio.  It appears
>I need to learn how to navigate Visual Studio 2005 as well as SQL Server
>2005.
>
>Here is an article I found about editing SQL Server 2005 stored
>procedures through Visual Studio -
>http://aspnet.4guysfromrolla.com/articles/051607-1.aspx
>
>Thanks for the help,
>
>Jennifer