One of my customers, had a requirement to identify the call graph (or other words dependency map) for the nested stored procedures. While with SQL 2008, two new DMVs viz sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities to identify the referencing and referenced objects by the stored procedures within the database. However, the DMV gives the information of the… Continue reading Dependency Map of the Nested Stored Procedures using DMV