For some reason, the code in my previous post does not work anymore.
Here an alternative:
DECLARE @Search varchar(255)='param'
SELECT name,definition,type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%'+@Search+'%'
|