Pedro,

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.