select sp.name as '数据对象名称',case sp.type when 'P' then '存储过程' when 'FN' then '函数' when 'TR' then '触发器' else '其他' end as '数据对象类型',
isnull(smsp.definition, ssmsp.definition) as [definition]
from
sys.all_objects as sp
left outer join sys.sql_modules as smsp on smsp.object_id = sp.object_id
left outer join sys.system_sql_modules as ssmsp on ssmsp.object_id = sp.object_id
WHERE
(sp.type = N'TR' or sp.type = N'P' or sp.type = N'FN') and
smsp.definition like '%表名%'
--使用的时候将表名替换你要查找操作的表名就可以了。