Recently working in Microsoft SQL Server I needed to find all the dependencires for a specific stored procedure. I ended up with the following:
This query looks through all the stored procedure definitions, in the MY_DB database, for the words
myStoredProcedure. The results will display all the stored procedures including the myStoredProcedure.