Listing All Stored Procedures of ALL Databases in SQL Server

Listing All Stored Procedures of ALL Databases in SQL Server

In this blog we see, How to list all the Stored Procedures from all the database in sql server.

 

? – Indicates the name of database.

This will iterate all the database in the sql server and list the sys Stored Procedures as section based on the database.

 

sp_msforeachdb 'select "?" AS dbName, * from [?].sys.procedures

 

You can also use like below,

                select * from [DatabaseName].sys.procedures

 

Thanks for reading this article. Have a nice day.