Eric Barro
ebarro at verizon.net
Tue Jun 26 22:03:18 CDT 2007
Jennifer, When you right click the sproc you should have an option to Modify or Script the sproc to a Query window. If the login you are using doesn't have permissions to do that then you won't be able to Modify the sproc. Eric -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross Sent: Tuesday, June 26, 2007 7:14 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.9/870 - Release Date: 6/26/2007 10:07 AM