Hi all

Can I get a list of SPs sorted by it's dependency weight, the SP most
dependent upon at the top which needs to be created first, reverse this
is the one that needs to be dropped last.

I wanted to manually drop old unused SPs and recreate the new ones. I
currently have a logic to do this but it needs to be run twice to get an
SP, that has changed it dependencies, to update.

Hope I was able to put forward my thoughts properly

Please advise

Kind regards
Bhavbhuti