I need to extract the dependent Stored procedure names across databases also. The current code displays only the dependent stored procedures that are present in the parent stored procedure database.
If Parent stored procedure named MainSP is present in Database1 and
its child stored procedures,
a. ChildSP1 is present in Database1
b. ChildSP2 is present in Database2
c. ChildSP3 is present in Database1
Then the current code will display only ChildSP1 and ChildSP3 in the tree and not ChildSP2. I need ChildSP2 also to be listed in the tree
If any one can has solution for it mail to firstname.lastname@example.org