On SQL server 2005 it could be just that:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%whateverstringyouneedtofind%''

AND ROUTINE_TYPE='PROCEDURE'

Greg from Moxy Media in Guelph