Mark A Matte
markamatte at hotmail.com
Wed Jun 27 10:04:41 CDT 2007
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