Here is a great tool by RedGate which allows the DBA to search throughout all objects in a database. The tool is integrated with SSMS, and it works for both SQL 2005 and SQL 2008.
Here are some benefits:
- you can easily find all references to an object in your database
- you can look up any object and “jump to it”
- you can search even for whole or fragments of words …
You can view more detail and download from this site.
