[mssql] SP에서 특정 TEXT 검색

use {{databaseName}}

SELECT DISTINCT 'EXEC sp_helptext [' + SCHEMA_NAME(SCHEMA_ID) + '.' + OBJECT_NAME(A.id) + ']'
FROM sys.syscomments A INNER JOIN sys.objects B ON A.id = B.object_id
WHERE TEXT LIKE '%{{검색어}}%'


SELECT
OBJECT_NAME(object_id)
FROM
sys.sql_modules
WHERE
definition LIKE '%{{검색어}}%'

출처 : http://modellerr.tistory.com/35