- With SQL Query Analyzer (SQL Server 2000) you can only search an object by its name.
- With SQL Server Management Studio (SQL Server 2005 and more) the Filter option is very limited.
- Sp_depends can provide many irrelevant results since SysDepends table could be out off sync.
SQLDBSearch is a small and visual tool that is intended to fix this limitation and helps SQL Server developers and DBA to find objects that might be affected when they implement a database change. SQLDBSearch can find an object by its name or content in a specified database or the whole server.
This tool supports SQL Server 2012, 2008, 2005 and 2000 and requires Microsoft .Net Framework 3.5 and above