Hi all, Lately I have been working on a Migration project in which I had to move data from an old SQL DB into a new one with a different schema (slightly different). In order to understand the differences I downloaded several free tool in which I could compare both schema. There are lots of good tool for that but during the project I also had to look out for things like:
1. Which stored procedures and Tables FK uses a given column?
2. Which tables contains a given ID
and much much more questions of that kind. So instead of using a stored procedures and system tables to perform the task I have found out that there is a free tool from the “Redgate” company that does exactly that:It is called “SQL Search” and here are some snap shots to let you understand how it works. (BTW it is fully integrated with SQL management studio 2005, 2008).
(You can filter which object types you want to search in : Tables, SP, Views etc)
Once clicked you can see the text and move to the SP.
Here is the link for the download:http://www.red-gate.com/products/SQL_Search/index.htm
Enjoy!