Published on: 11 Jan, 2013

How to list all stored procedures in SQL Server?

Tumblr Digg Google Plus

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'

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.