April 30, 2002 at 6:49 pm
I have a vendor delivered application that has a number of stored proceudres and sone stored proceudres call other stored procedures.
Is there a way i can retrieve information about the stored procedures being called from a particular stored procedure.
WHen i try using sp_depends it lists only the tables but not the stored proceudres.
Thanks in advance.
Jo
April 30, 2002 at 7:44 pm
I think that this script from another forum could help you out or at least push you in the right direction:
May 2, 2002 at 2:23 pm
Jo,
You've got me on this one!
I've created a stored procedure, that will give you exactly what you are looking for:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=315
Let me know, please, if it worked for you.
Eva
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply