SELECT o.Name AS 'StoredProcedure'
FROM SysObjects AS o
INNER JOIN SysComments AS c ON o.ID = c.ID
WHERE c.[Text] LIKE '%testo da ricercare%'
AND o.[Type] = 'P'