I have always been a Sql junkie. Analyzing data was one of the things that I enjoy alot...
Sometimes this task also involves writing gargantuan scripts.. and that is where the problem starts. Finding what stored procedure or view that uses a specific table could give you a hard time since SQL server doesn't have a feature that enables you to look at each and every stored procedure and view. usually when this problem arises we tend to open each and every script that we could think of(when this happens i usually script my database, open the generated .sql file in note pad and start using the Find function to search for the table/view name).
Pretty tough huh?! an easier approach is to use MS SQL Search from the guys at CodeAlchemy. The tool is a WinForm application that enables you to do a quick search on your database(much like google desktop except that this is for db). Impressive. Cool. Nice!
Check it out here.