select
db_name() [database name]
,[schema name] = SCHEMA_NAME([schema_id])
,o.name
,create_date [create date]
,modify_date [last modify date]
,ps.last_execution_time
from sys.dm_exec_procedure_stats ps
inner join
sys.objects o
ON ps.object_id = o.object_id
where o.type = 'P'
–and o.schema_id = schema_name(schema_id)
and o.name = 'MonTlogUsage'… Read the rest