[dba-SQLServer] Viewing and Modifying stored procedures

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


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 





More information about the dba-SQLServer mailing list