When you do not have access directly to a SQL Server Management Studio and only have the ability to run the query via web page, you probably want to know how you can get a list of stored procedures stored in the current database. You might also interested to view each stored procedure definition. In this tutorial you will learn a quick snippet code on how to view them.
To view all stored procedures, you can run the following sql query
SELECT * FROM sys.procedures;
To view individual stored procedure definition, you can run the following syntax:
sp_helptext 'stored_procedure_name'