Stored Procedure Call Hierarchy

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by cneuhold » Stored Procedure Call Hierarchy

Stored Procedure Call Hierarchy

Rate Topic

Display Mode

Topic Options

Author

Message

cneuhold

Posted Saturday, October 13, 2007 10:30 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 8:50 AM
Points: 245, Visits: 11

Comments posted to this topic are about the item Stored Procedure Call Hierarchy

Post #410539

rbalaerd

Posted Friday, November 23, 2007 2:45 AM

Forum 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

« Prev Topic | Next Topic »

Permissions