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

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

转载于:https://www.cnblogs.com/wanyu/p/8430276.html