Jennifer Gross
jengross at gte.net
Tue Jun 26 10:56:01 CDT 2007
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