Last time stored procudure executed

[azeke]

Is there a system table that stores the last time a stored procudere was executed?

 

[osjohnm]

I'm not sure if there is a table that will store the last execution time of a stored procedure. There is a system table called syscomments but that only displays the tasks that occured eg: create procedure sp_trolley_status.

If your stored procedure(s) are executed by a job look at the last execution date of the job in enterprise manager.

 

[tlbroadbent]

SQL Server does not automatically track execution of procedures, access to tables, view or other objects. You will need to develop your own audit trail code. There may be 3rd party software to track this info. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.