--触发器不能通过
select 'exec sp_refreshsqlmodule '''+schema_name(schema_id)+'.'+name+''''
from sys.objects
where TYPE in ('FN',/*'TR',*/'IF','TF')
--触发器不能通过
select 'exec sp_refreshsqlmodule '''+schema_name(schema_id)+'.'+name+''''
from sys.objects
where TYPE in ('FN',/*'TR',*/'IF','TF')