• Yes, I have been using sp_helpdb databasename. this gives me DB name, logical DB name, physical file locations, size, owner.....

    From there I am able to cut and paste what I need into excel but it's tedious...