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