查看存储过程创建修改时间

select name 过程名,create_date as 创建时间,modify_date as 修改时间 from sys.procedures order by modify_date desc

select name 过程名,create_date as 创建时间,modify_date as 修改时间 from sys.views order by modify_date desc