Find stored procedure containing text in sql server

Use this query to find stored procedure containing text in sql server:

SELECT name

FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%YourKeyword%'


Best Wishes,

LadyinProgramming