Try to move this to TSQL Group, I am bit not clear on your full requirement but assuming you are searching for sp having text so try this
-- Step 1 :
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
WHERE ROUTINE_DEFINITION LIKE '%9251429%'
-- Step 2 :
WHERE [text] LIKE '%9251429%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.