Here is a query that you can execute in MS SQL Server's Query Analyzer to find some text string in any stored procedure defined in your database. This is very useful if you change the name of a table or something like that, and need to know what procedures to udpate.
declare @textToFind varchar(300)
set @textToFind = 'Store'
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
WHERE ROUTINE_DEFINITION LIKE '%' + @textToFind + '%' AND ROUTINE_TYPE='PROCEDURE'
It returns a list of the names of all stored procedures that contain your text string.