One place to look is the sp_depends procedure.
To use, just call it and give the object name. This is an example for a trigger. (You can look it up in BOL for specifics and other parameters to use.)
EXEC sp_depends @objname = N'AdventureWorks.Production.iWorkOrder' ;
You will have to call it for each object that shows up if you want to follow the trail.
In SSMS, you can right click a table, SPROC, etc. and choose View Dependencies. This gives a hierarchical view of the dependencies.
Hope this gets you started.