Ref.
MSSQL에서 특정 텍스트 포함 프로시저 검색하기
SELECT OBJECT_NAME(object_id) AS NAME, OBJECT_DEFINITION(object_id) AS CONTENT FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%검색할텍스트%'