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'