Find strings in text of stored procedures

Ussualy this kind of scripts queries sysobjects and syscomments like this:

select distinct object_name(O.id)
from syscomments as C
join sysobjects as O on O.id = C.id
and o.type = 'P' -- search string only in stored procedures
where C.text like '%insert into MyTable%'


When the text of stored procedures, triggers, functions is over 4000 characters, it is
saved in syscomments on many records. The string I want to find may be splitted in 2
records:

......................insert in
to MyTable.....................

In this case the upper query will not work.

This script creates a temporary table with a [text] column where the entire text of stored
procedure is saved. It applies LIKE on that column and in this way no result is lost.
It also shows the number of occurrences of the string.