Discovering Nested References in SQL Server

Tom Zika is helping:

The original question lists these requirements:

1. Information about all the tables referenced by a stored procedure
2. Also, list tables from cross-DB query
3. Return DB, Schema and Table names

Read on for a script to set up the example and then a query to build out these references.