var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to find out when storage procedure was last time executed
I would really appretiate if someone would come with idea, how I can trace when storage procedure was last time executed. Single idea at this point is to put trigger on systemprocesses table
I don't understand what you mean by "storage procedure"...
In any case you can't put a trigger on a system table, so some other solution will be needed.
MDA tables capture information each time a store procedure is run. So if you write a job to poll into a reposiory table monSysStatement where ProcedureID != 0 and object_name(ProcedureID,dbid) with a getdate() appended at the end should do the trick.
Last time a stored proc was executed
If you can afford to change the code
introduce a logging insert and subsequent update statement as proc begins and ends.
Then you can query this table for the info !