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 2000 to 2019 versions) and requires Microsoft .Net Framework 4.0 and above 

If you want to know all places where the 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.

Click here to download the tool

Require: Microsoft .Net Framework 4.0 and above

Click here to see some snapshots