Search string in stored procedures of SQL

A select statement that is running somewhere in our system and putting an extremely heavy load on the server. We would like to fix it, but we can't seem to locate it. We believe it is either hard coded into the reporting server, or somewhere in a stored procedure possibly

declare @SearchStr      varchar(100)
set @searchstr = 'String to search for'
SELECT DISTINCT USER_NAME(o.uid) + '.' + OBJECT_NAME(c.id) AS 'Object name'
FROM  syscomments c
      INNER JOIN
      sysobjects o
      ON c.id = o.id
WHERE c.text LIKE '%' + @SearchStr + '%'  and
      encrypted = 0