InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:06:41 GMT20http://www.sqlservercentral.com/Forums/Topic1370774-392-1.aspxPedro,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.Thu, 11 Oct 2012 07:43:11 GMTvikingDBAhttp://www.sqlservercentral.com/Forums/Topic1370774-392-1.aspxHi,Is there any easy way of determining nested triggers?!For example, if I update a table that has an update trigger and that triggers call and SP the does an insert on another table that has a trigger, is there a way of getting this dependencies?!Thanks,PedroWed, 10 Oct 2012 03:02:14 GMTPiMané