paul.hartland at fsmail.net
paul.hartland at fsmail.net
Tue Jun 26 10:13:24 CDT 2007
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