Too many times I have needed to find a piece of code that calls a view, proc or table. If you are using any of Microsoft’s developer products you can do “Find in solution” but it takes a month. You can also go to the server, browse to the folder and click search only to get no results. Well, I have a solution.
Unix and Linux people may remember grep. Well, there is a windows version called Wingrep ( http://www.wingrep.com/ ). Install it. Use it. Find the files you need.