Obtendo uma lista de dependências de um procedure

ProcedureDependencies.sql

SELECT
  s.name + '.' + p.name AS procedureName
  ,(
    SELECT DISTINCT
      STUFF(REPLACE((SELECT '#!' + LTRIM(RTRIM(q.tableName)) AS 'data()'
      FROM
      (
        SELECT DISTINCT
          ts.name + '.' + t.name AS tableName
        FROM sys.dm_sql_referenced_entities(s.name + '.' + p.name, 'OBJECT') AS r
        INNER JOIN sys.tables AS t ON t.object_id = r.referenced_id
        INNER JOIN sys.schemas AS ts ON ts.schema_id = t.schema_id
      ) q
      FOR XML PATH('')), ' #!', ';'), 1, 2, '') AS dependencies
  ) AS dependencies
FROM sys.procedures AS p
INNER JOIN sys.schemas AS s ON s.schema_id = p.schema_id