SELECT ROUTINE_NAME, ROUTINE_TYPE
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE @searchText
ORDER BY ROUTINE_NAME

SELECT
    ROUTINE_NAME,
    ROUTINE_TYPE,
    ROUTINE_DEFINITION as First4000,
    OBJECT_DEFINITION(object_id(ROUTINE_NAME)) as FullDefinition
FROM
    INFORMATION_SCHEMA.ROUTINES
WHERE
    OBJECT_DEFINITION(object_id(ROUTINE_NAME)) LIKE @searchText
ORDER BY
    ROUTINE_NAME

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE ‘%strHell%’