Mareo Code

--Just run below code in the context of your database.

SELECT
    [name]
    , create_date
    , modify_date
FROM
    sys.procedures
WHERE
    [type] = 'P'
    AND is_ms_shipped = 0
    AND [name] NOT LIKE 'sp[_]%diagram%'
ORDER BY
    modify_date DESC

-- For simple count number of stored procedures in current database:
SELECT
    COUNT(*) as QuantitySP
FROM
    sys.procedures
WHERE
    [type] = 'P'
    AND is_ms_shipped = 0
    AND [name] NOT LIKE 'sp[_]%diagram%'