nested procedure table

[Sasmi_Office]

Dear Friends, i have one issue in using nested procedure, both procedure having hash table with same name because of which there is an issue for executing same procedure through ASP.net (it not showing issue in sql server) so i need how to find nested procedure from huge database Sasmi

[Mycroft Holmes]

The text of a procedure is stored in a system table in SQL server, from this you can do a string match to find the offending text and identify the procedures using it. This search[^] throws up a number of possibilities.

Never underestimate the power of human stupidity RAH