Search anything in your data base with Sql search a red gate free tool

Red Gate has give free SQL search tool.SQL search is good tool for searching part of word in table ,SP,view in almost all objects in MS SQL.

Following is screen shot of search performed.



It also opens up the object found by just double clicking on it.




I found this tool use full you can try by downloading it from

http://www.red-gate.com/products/SQL_Search/