One more thing to keep in mind, if the proc has more than 4000 characters and that the objects used is splitted between 2 rows in syscomments, that still won't work (quite rare, but it does happen).

The solution is to left join on syscomments on c1.id = c2.id and c1.colid = c2.colid + 1

then do the search on c1.text + isnull(c2.text,'') like '%Whatever%'

That was true in 2000, maybe it's been fixed in 2005, but I'd be surprised.