The following Microsft SQL Server stored procedure will locate all stored procedures with the specified keyword:

-- SQL Server search stored procedure definitions - database metadata

USE AdventureWorks2008;

GO

-- LIMITATION: stored procedure definition < 4000 bytes 

CREATE PROCEDURE FindProcs

                @KeyWord VARCHAR(512)

AS

  SELECT   routine_name

  FROM     INFORMATION_SCHEMA.ROUTINES

  WHERE    routine_definition LIKE '%' + @KeyWord + '%'

  ORDER BY routine_name

GO

-- Execute stored procedure

EXEC FindProcs 'Material'

GO

/*

routine_name

uspGetBillOfMaterials

uspGetWhereUsedProductID

*/