Last Compile Date

To check the last date of compile for a SQL procedure use this query:

select modify_date
from sys.all_objects o
where o.type = 'P'
and lower(o.name) = 'theprocname'