Hi asdawkins 16457
Thank you for your kind words, appreciate it.
Thanks for this. I will be using it a lot.
How do I add a column that shows the "last execution date"?
I was checking the Last Execution Date for your query and it you would be better of using the DMV - SYS.DM_EXEC_PROCEDURE_STATS which has a Last execution Time Column which can be used.
An example - SYS.DM_EXEC_PROCEDURE_STATS
SELECT SO.NAME, EPS.LAST_EXECUTION_TIME , EPS.EXECUTION_COUNT
FROM SYS.DM_EXEC_PROCEDURE_STATS EPS
INNER JOIN SYS.OBJECTS SO ON EPS.OBJECT_ID = SO.OBJECT_ID
WHERE EPS.DATABASE_ID = DB_ID() -- FILTER BY CURRENT DATABASE
ORDER BY EPS.EXECUTION_COUNT DESC
Please check http://msdn.microsoft.com/en-us/library/cc280701.aspx for more details.
E&OE - Other variations of this script might be existing too.
Hope this helps.