关键字查找相关的存储过程、触发器、函数和视图

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

SELECT NAME
	,type_desc
FROM sys.all_sql_modules s
INNER JOIN sys.all_objects o ON s.object_id = o.object_id
WHERE DEFINITION LIKE '%keyword%'
ORDER BY type_desc
	,NAME