SQLDBSearch is a free SQL Server tool that lets you easily and quickly search for database objects or SQL statements across your databases.
This tool supports all versions of SQL Server (from SQL Server 2014 to 2000 versions) and requires Microsoft .Net Framework 3.5 and above
If you want to know all places where specific column is used, this is a great tool to use.
If you want to know tables, views or stored procedures dependencies, this is a good tool to use.
If you want to rename a table or column but aren't sure what views, stored procedures or function reference it, this is a great tool to use.
If you are looking for a bad SQL statements like SELECT * in the text of views, stored procedures or functions, this is a good tool to use.