查看存储过程最后修改时间

select name,modify_date from sys.all_objects where type=’P’ order by modify_date desc