In this article, I will explain how to get all stored procedure names from SQL Server Database. The below mentioned query will list all the stored procedures (Routines) available in the database.
select Routine_Catalog, Routine_Schema, Routine_Name, Routine_Type from information_schema.routines where routine_type = 'PROCEDURE' order by Routine_Name
In the above sample, Routine_Catalog is the Database Name, Routine_Name is the procedure name.
The mentioned below is the output for the above query.