Redgate has developed a very useful tool to search for code between all your storeds, functions and tables etc. inside your SQL Server databases: http://www.red-gate.com/products/sql-development/sql-search/
It works with Microsoft SQL Management Studio 2005, 2008, Denali or the 2008 Express version (which is free).
Note: If you try to install the x64 but on the menu to select what to install you don’t have the “Management Studio” listed, try the x86 as I downloaded a few times the x64 but instead of installing the Management Studio was installing the SQL Server Express 2008 only.
