Cercare il testo all'interno di una Storeprocedure

Può tornare comodo:
DECLARE @StringToSearch varchar(100)
SET @StringToSearch = '%testo da cercare%'

SELECT Distinct SO.Name
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
AND SO.Type = 'P'
AND SC.Text LIKE @stringtosearch
ORDER BY SO.Name



Oppure:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%testo da cercare%'
AND ROUTINE_TYPE='PROCEDURE'