Search a particular text string in all SPs

http://www.sqlservercentral.com/Search/?q=search+text+in+sp&t=a&t=b&t=f&t=s
********************************************************

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%Prod%'

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE Definition LIKE '%Prod%'
AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1

--nvarchar(4000)
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Prod%'
AND ROUTINE_TYPE = 'PROCEDURE'
********************************************************