查询最近修改过的存储过程和自定义函数

select * from sys.objects
where modify_date>dateadd(day,-30,getdate())
and (type='P'or type='FN' or type='V')