• 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 proc_name,table_name

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

    Update: Edited Ordinal Order By per Sean's suggestion