db_name() [database name]
,[schema name] = SCHEMA_NAME([schema_id])
,create_date [create date]
,modify_date [last modify date]
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'
order by ps.last_execution_time

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.