This will get you half way there:
It will tell you the last time a stored proc was executed.
As for who ran it, as far as I know that is not recorded. You could use profiler to recored this, but i wouldn't do that on production server.
answered Oct 23 '09 at 02:59 PM