[dba-SQLServer] Viewing and Modifying stored procedures

Jennifer,

When you right click a sproc you get a context-sensitive menu with an option
called Modify. If you don't have that option then the login you are using
might not have permissions 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 8:03 AM
To: SQL Server List
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