Count the number of Stored Procedure in a database

SELECT COUNT(*) AS PROCEDURE_COUNT 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_TYPE = 'PROCEDURE'

Select the Database and execute the above code !



Thanks and Regards
Akiii