T-SQL Hierarchy to duplicate Dependent Objects tree view in SQL Server 2005

Posted by drewg on Stack Overflow See other posts from Stack Overflow or by drewg
Published on 2010-04-21T13:46:27Z Indexed on 2010/04/21 20:43 UTC
Read the original article Hit count: 225

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about t-sql

Related posts about hierarchy