Mark A Matte
markamatte at hotmail.com
Wed Jun 27 14:43:08 CDT 2007
Jennifer, After I read the other posts...I went back and looked at my version of SQL Server...to find out how to edit a SP without the double click...if I right click on the SP and choose PROPERTIES...it opens the same edit window as the double click. Hope that helps, Mark >From: "Mark A Matte" <markamatte at hotmail.com> >Reply-To: dba-sqlserver at databaseadvisors.com >To: dba-sqlserver at databaseadvisors.com >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures >Date: Wed, 27 Jun 2007 15:04:41 +0000 > >I use SQL Server Enterprise Manager to modify the SP...never did it through >Query Analizer... > >Sorry, > >Mark > > > >From: "Jennifer Gross" <jengross at gte.net> > >Reply-To: dba-sqlserver at databaseadvisors.com > >To: <dba-sqlserver at databaseadvisors.com> > >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures > >Date: Tue, 26 Jun 2007 19:13:44 -0700 > > > >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 > > > > > > > >-----Original Message----- > >From: dba-sqlserver-bounces at databaseadvisors.com > >[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A > >Matte > >Sent: Tuesday, June 26, 2007 1:32 PM > >To: dba-sqlserver at databaseadvisors.com > >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures > > > > > >Jennifer, > > > >I currently use an older version of SQL Server...7 actually...and all I > >have > >to do is double click a stored procedure and it opens in a window for me > >to > >edit it... > > > >Probably not useful...just thought I'd share. > > > >Mark A. Matte > > > > > > >From: "Jennifer Gross" <jengross at gte.net> > > >Reply-To: dba-sqlserver at databaseadvisors.com > > >To: <dba-sqlserver at databaseadvisors.com> > > >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures > > >Date: Tue, 26 Jun 2007 09:44:48 -0700 > > > > > >Thanks Robert. It is sinking in that this is the way it works in SQL > > >Server. Even if I just want to see the stored procedure so that I can > > >understand what it does (since I inherited this database), I have to > > >generate this ALTER PROC template and then close the window without > > >saving. Seems strange that I just can't take a look at the stored > > >procedure code, but I guess that's the way it is. > > > > > >Jennifer > > > > > >-----Original Message----- > > >From: dba-sqlserver-bounces at databaseadvisors.com > > >[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert > > >Sent: Tuesday, June 26, 2007 9:36 AM > > >To: dba-sqlserver at databaseadvisors.com > > >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures > > > > > > > > >Jennifer, > > > > > >That is the "editing" window. > > >Not sure what you expected. > > > > > >If you were expecting a grid view, > > >then you are not going to get it. > > >Stored procs are not views, but > > >can be anything from a simple SQL > > >statement to hundreds of lines > > >of code to do complex things. > > > > > >If the stored proc is a simple > > >select statement and you are not > > >comfortable writing SQL, use the > > >view to create the SQL for you. > > >Then copy and paste it into the > > >stored proc. > > > > > >The ALTER statement is how the > > >code for the stored proc is saved > > >when you change it. What it is doing > > >is making a copy of your SP then > > >allowing you to change it. If you > > >goof up, you just close the window > > >and don't save or execute it. Then > > >open the SP again to get the original > > >ad start your editing again. > > > > > >Robert > > > > > > > > >At 11:26 AM 6/26/2007, you wrote: > > > >Date: Tue, 26 Jun 2007 09:16:55 -0700 > > > >From: "Jennifer Gross" <jengross at gte.net> > > > >Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures > > > >To: "SQL Server List" <dba-sqlserver at databaseadvisors.com> > > > >Message-ID: <00d701c7b80d$6d78afe0$6501a8c0 at jefferson> > > > >Content-Type: text/plain; charset=us-ascii > > > > > > > >Hi Elizabeth, > > > > > > > >Yes, I have modify. What it does is set up a template T-SQL script > > > >to modify the stored procedure. If that is the only way to do it, > > > >then that is how I will have to work with it. I was hoping for just > > > >an editing window. Since I inherited this database what I really > > > >want to do is poke around and look at the code and I can't seem to > > > >find any way > > > > > > >to just look at the code without generating one of these T-SQL > > > >templates. > > > > > > > >I hope that makes sense. > > > > > > > >Jennifer > > > > > > > > >_______________________________________________ > > >dba-SQLServer mailing list > > >dba-SQLServer at databaseadvisors.com > > >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > >http://www.databaseadvisors.com > > > > > > > > > > > >_______________________________________________ > > >dba-SQLServer mailing list > > >dba-SQLServer at databaseadvisors.com > > >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > >http://www.databaseadvisors.com > > > > > > >_________________________________________________________________ > >Picture this - share your photos and you could win big! > >http://www.GETREALPhotoContest.com?ocid=TXT_TAGHM&loc=us > > > > > > > >_______________________________________________ > >dba-SQLServer mailing list > >dba-SQLServer at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >http://www.databaseadvisors.com > > > >_________________________________________________________________ >Hotmail to go? Get your Hotmail, news, sports and much more! >http://mobile.msn.com > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > _________________________________________________________________ Who's that on the Red Carpet? Play & win glamorous prizes. http://club.live.com/red_carpet_reveal.aspx?icid=REDCARPET_hotmailtextlink3