Home > IT Answers > SQL Server > Viewing created stored procedures in SQL Server
SQL Server Ask the Experts
2,585 pts.
 Viewing created stored procedures in SQL Server
Stored Procedures
How can I view stored procedures that have already been created in SQL Server?

Software/Hardware used:
ASKED: August 5, 2008  3:13 PM
UPDATED: August 6, 2008  3:03 AM
RELATED QUESTIONS
Answer Wiki:
You can use the sp_helptext procedure to query the system for the source of the procedure. You can also right click on the procedure in Enterprise Manager or Management Studio and select the Modify or Edit option.
Last Wiki Answer Submitted:  August 6, 2008  3:03 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.