How do I find all stored procedures in a database?

 You can retrieve the list of all stored procedures using the following query:

SELECT 
    name AS ProcedureName,
    create_date,
    modify_date
FROM 
    sys.procedures
ORDER BY 
    name;
This returns all stored procedures along with their creation and modification dates.