Elizabeth.J.Doering at wellsfargo.com
Elizabeth.J.Doering at wellsfargo.com
Tue Jun 26 11:31:40 CDT 2007
Yup, changing a proc is "alter" and it doesn't save until you 'execute'. Nothing so nice and direct as VBA where you see something, make a change and save it. You have to run a proc to accomplish EVERYTHING in SQL server. I too am learning this the hard way, having been working in SQL Server 2000 and 2005 simultaneously and from absolute zero since October. Tons of Access experience is one thing; SQL server is a different world. Liz -----Original Message----- From: Jennifer Gross [mailto:jengross at gte.net] Sent: Tuesday, June 26, 2007 11:26 AM To: Doering, Elizabeth J. Cc: SQL Server List Subject: RE: [dba-SQLServer] Viewing and Modifying stored procedures 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