How to find the Custom text in a stored procedures using SQL Server

SELECT OBJECT_NAME(object_id)

    FROM sys.sql_modules

    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1

    AND definition LIKE '%yourText%'