Hi,

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.

For Eg:

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 rbalaerd@yahoo.co.in

- Bala