This Addin for SQL Server Management Studio 2005 allows you to find Stored Procedures, Functions and Triggers that definition contain a specified string.
You can open the search window by selecting "Object Finder" from the Tools menu or by using the hotkey ctrl/shift/F.
Enlarge or dock the window so that it fits your needs.
Select a database from the Object Explorer you want to search through. Enter the phrase and klick on the search button. The objects containing the string are getting listed. You can open the definition by double-click on a list entry.