In my one of earlier articles here I wrote about a way to find any value in any database column. Today, I found a great free tool, from RedGate, to find dependencies of any object. The tool “SQL Search” is available here. This can be used for impact analysis, improving the performance by replacing “Select *” with actual column name etc.
The best part is that it installs as an SSMS plugin, making it very easy to use it.
I recommend every SSMS user to give it a try.
Advertisement
