MS-SQL 뷰(View), 프로시져(Procedure), 트리거(Trigger), 함수(Function) 내부 단어 검색

DECLARE @SEARCH NVARCHAR(MAX) = '검색텍스트';

SELECT B.NAME AS NAME -- 이름
     , B.TYPE_DESC AS TYPE -- 타입 구분
     , A.DEFINITION AS CONTENTS -- 내용
FROM  SYS.SQL_MODULES A WITH (NOLOCK)
LEFT JOIN SYS.OBJECTS B WITH (NOLOCK) ON A.OBJECT_ID = B.OBJECT_ID
WHERE DEFINITION LIKE '%' + @SEARCH+ '%'
ORDER BY TYPE, NAME