How to get the most dependent stored procedure in SQL Server using T-SQL?
<p>I am trying to get the most dependent stored procedure in SQL Server Management Studio 2014. I have a huge database which has almost 1900 stored procedures, 453 tables, 768 views and 419 functions altogether. Some of the stored procedures are very big (4089 lines) which is nested with many stored procedures, views and functions. I want to redesign the architecture and the software itself.</p>

<p>I want to get the report of the most dependent stored procedure with the dependent object name.</p>

<p>I have searched for it but I have not get a appropriate solution. </p>