kylemit (5/16/2014)

---

This answer uses a number of deprecated tables that will no longer be supported.

Here's a simpler way to achieve the same thing:

SELECT DISTINCT p.name AS proc_name, t.name AS table_name

FROM sys.sql_dependencies d

INNER JOIN sys.procedures p ON p.object_id = d.object_id

INNER JOIN sys.tables t ON t.object_id = d.referenced_major_id

ORDER BY 1,2

For more info, you can see my answer on stack overflow about this issue.