T-SQL Hierarchy to duplicate Dependent Objects tree view in SQL Server 2005
- by drewg
Hi
Id like to map the calling stack from one master stored procedure through its hundreds of siblings. i can see it in the dialog, but cannot copy or print it, but couldnt trap anythiing worthwhile in proflier.
do you know what sproc fills that treeview? i must be a recursive CTE that reads syscomments or information_schema.routines, but its beyond my chops, though i can imagine it
thanks in advance
drew