Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored Procedure Call Hierarchy Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 10:30 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 5, 2013 1:19 AM
Points: 245, Visits: 13
Comments posted to this topic are about the item Stored Procedure Call Hierarchy


Post #410539
Posted Friday, November 23, 2007 2:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 23, 2007 3:01 AM
Points: 1, Visits: 1
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
Post #425195
Posted Thursday, May 22, 2014 3:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:14 AM
Points: 1, Visits: 13
Hi,

Thank you for the script for viewing the hierarchy. But I am still suspicious about the outcome that I am getting after executing the Script. Can you please explain the working of the script? Because there are lots of places where the same stored procedure is called, but its hierarchy is not being displayed. So either the script is having something missing or the script is not 100% correct.

If you can explain me the script, we both can work on it together and make the script work as expected.

Thank you.
Post #1573469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse