[dba-SQLServer] Viewing and Modifying stored procedures

Jennifer Gross jengross at gte.net
Tue Jun 26 11:26:22 CDT 2007


Hi Liz,

Yup, I have the stored procedure selected.  It is just that the Modify
option doesn't just show me the stored procedure, it is creating a T-SQL
template - it adds the commands ALTER PROC, etc. which are not part of
the stored procedure, but the means of modifying the stored procedure -
so that you can modify the script and run it to modify the stored
procedure.

I was hoping for a way to look at just the stored procedure, maybe edit
it without having to run an ALTER PROC script, and then save it.  Kind
of like with VB or VBA where you just have an editing window for your
code.  You make the changes in-line and then do a save.

I guess that is just not how it works with SQL Server.  I am learning!

Jennifer



-----Original Message-----
From: Elizabeth.J.Doering at wellsfargo.com
[mailto:Elizabeth.J.Doering at wellsfargo.com] 
Sent: Tuesday, June 26, 2007 9:18 AM
To: jengross at gte.net
Subject: RE: [dba-SQLServer] Viewing and Modifying stored procedures


Did you click on the stored procedure you want to modify first??  Sorry
if that is too simple an answer!


Liz 


-----Original Message-----
From: Jennifer Gross [mailto:jengross at gte.net] 
Sent: Tuesday, June 26, 2007 11:16 AM
To: Doering, Elizabeth J.
Subject: RE: [dba-SQLServer] Viewing and Modifying stored procedures

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

-----Original Message-----
From: Elizabeth.J.Doering at wellsfargo.com
[mailto:Elizabeth.J.Doering at wellsfargo.com]
Sent: Tuesday, June 26, 2007 9:10 AM
To: jengross at gte.net
Subject: FW: [dba-SQLServer] Viewing and Modifying stored procedures


Jennifer,

Don't you have the right click option 'Modify'?  That would be your
friend here.  You can see it on the attached screen shot, and it gives
the results shown as well.

HTH,

Liz 


Liz Doering
elizabeth.j.doering at wellsfargo.com
612.667.2447


This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.


-----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 10:56 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures

Hi Paul,

This is what I hoped as well, but it doesn't seem to be the case.  The
right click menu gives me the option to script a modification, or script
a re-creation of the stored procedure, plus some other stuff.  But I am
not seeing a way to just open the stored procedure, see the code, modify
it and save it again.

Jennifer

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Tuesday, June 26, 2007 8:13 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Viewing and Modifying stored procedures
Importance: High


Jennifer

One of the folders inside your database should be called programability,
in there you will find the stored procedures, then I am sure (bit rusty,
as not used it in a while) you should be able to right click and modify
it.  Hope this helps as I haven't really had much chance myself to play
with 2005

Paul 







Message Received: Jun 26 2007, 04:04 PM
From: "Jennifer Gross" 
To: "SQL Server List" 
Cc: 
Subject: [dba-SQLServer] Viewing and Modifying stored procedures

Hi All,

I am brand new to SQL Server - using 2005. I am tasked to make changes
to a db developed by someone else. For the life of me I cannot figure
out how to view a stored procedure and modify it. Using Management
Studio I was hoping that a right click would yield an Open or Design
option - but no luck. Do I have to modify via T-SQL or is there an
editing window I can use?

Thanks in advance,

Jennifer Gross
databasics
2839 Shirley Drive
Newbury Park, CA 91320-3068
office: (805) 480-1921
fax: (805) 499-0467 


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






Paul Hartland
paul.hartland at fsmail.net
07730 523179
_______________________________________________
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










More information about the dba-SQLServer mailing list