That was doing a good job in 2003. I have not tried it since so maybe it can help you out.
There's a free trial so you should have enough time to check it out before having to buy :
http://www.red-gate.com/products/sql-development/sql-dependency-tracker/