MS SQL SERVER: Find all objects that a Stored Procedure or Function in SQL Server Uses

SELECT TOP (100) PERCENT OBJECT_NAME(d.object_id) AS SP_Or_Function, OBJECT_NAME(d.referenced_major_id) AS TableReferenced

FROM sys.sql_dependencies AS d INNER JOIN

sys.all_sql_modules AS m ON m.object_id = d.object_id

GROUP BY OBJECT_NAME(d.object_id), OBJECT_NAME(d.referenced_major_id)

ORDER BY SP_Or_Function, TableReferenced