SSMS Addins - Object Finder - DataScripter

<div class="posterous_quote_citation">
  via <a href="http://ssmsaddins.codeplex.com/">ssmsaddins.codeplex.com</a>
</div>

<p>
  While searching yet again for the SQL to find a particular piece of text inside SQL server proc definitions I came across this cool Addin project that does exactly that and also has other cool features like generating the data insert scripts for a table.
</p>