[mssql] 특정 문자열 포함 sp 명 반환

SELECT
    ROUTINE_NAME
FROM
    INFORMATION_SCHEMA.ROUTINES
WHERE
    ROUTINE_DEFINITION LIKE '%{{문자열}}}%'
    AND ROUTINE_TYPE = 'PROCEDURE'
order by
    ROUTINE_NAME