查询具体数据库中的存储过程：

use [数据库名]

select last_execution_time '最近一次执行时间'
 from sys.dm_exec_procedure_stats
 where type='P' 
 and database_id=db_id('[数据库名]')
 and object_id=object_id('[存储过程名]')

查询所有数据库的存储过程：

SELECT database_id,* FROM sys.databases WHERE database_id> 4

SELECT 
    a.name AS 存储过程名称,
    a.create_date AS 创建日期,
    a.modify_date AS 修改日期,
    b.last_execution_time AS 最后执行日期,
    b.execution_count AS 执行次数
FROM sys.procedures a 
LEFT JOIN sys.dm_exec_procedure_stats b ON a.object_id = b.object_id AND b.database_id ='上面查询的数据库ID'
WHERE a.is_ms_shipped =0 --去掉系统存储过程
ORDER BY b.database_id