Locating objects and references when working with large databases

Fridthjof Eriksen's very first blog entry is a useful one titled locating objects and references when working with large databases, where he reveals a stored procedure that will search through the syscomments and sysobjects sys tables to find all occurrences that match a string. I can see how useful this can be when troubleshooting.