... until the collector arrives ...
While evaluating changes to the PetroAra schema, I took a look at the product ApexSQL Clean. It performs SQL Server dependency analysis, among other things. The product is pretty slick.