[dba-SQLServer] Viewing and Modifying stored procedures

Jennifer Gross jengross at gte.net
Wed Jun 27 13:54:04 CDT 2007


Hi Robert,

Wow.  I never expected or received such animosity and direct criticism
from a request for help from this list or any other I belong to.  

Jennifer

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Wednesday, June 27, 2007 10:54 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list