您可以使用此按钮查看"Procedures“列表

SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE="PROCEDURE" 
AND ROUTINE_SCHEMA="dbname";

您可以了解更多here

试试这个解决方案，只需替换最后一行中的数据库名称。

SELECT count(ROUTINE_NAME)procedure_count
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE="PROCEDURE" 
AND ROUTINE_SCHEMA="your database name";

这对我很有效

SELECT     
    COUNT(*) as 'Stored Procedures'     
FROM SYS.OBJECTS
WHERE TYPE ='P'
GROUP BY TYPE