MSSQL 프로시저 찾기 (find procedure containing text in sql server)

    SELECT ROUTINE_NAME

    FROM INFORMATION_SCHEMA.ROUTINES

    WHERE ROUTINE_DEFINITION LIKE '%찾을내용%'

         AND ROUTINE_TYPE='PROCEDURE'

    ORDER BY ROUTINE_NAME