T-SQL: Summary of all Databases on server

/* ALL DATABASES GENERAL INFO */

DECLARE @helpdb TABLE (dbname varchar(500), dbsize varchar(100), dbowner varchar(500), dbid1 int, dbcreated varchar(50), dbstatus varchar(1000), dbcompatibility_level int)
INSERT INTO @helpdb (dbname, dbsize, dbowner, dbid1, dbcreated, dbstatus, dbcompatibility_level) 
EXEC sp_helpdb
-- SELECT * FROM @helpdb

SELECT  @@SERVERNAME AS Server 
,d.dbname AS DBName 
,DATABASEPROPERTYEX(d.dbname,'status') as DBStatus
,DATABASEPROPERTYEX(d.dbname,'Recovery') as 'DBRecovery'
,d.dbowner as DBOwner
,d.dbcreated as create_date1
,CONVERT(smalldatetime,sdb.create_date) as create_date2
,sdb.create_date as create_date3
,(mdf.size + ldf.size) / 128 as DBTotal_MB
,mdf.size / 128 AS mdb_MB
,ldf.size / 128 AS ldf_MB
,mdf.name+'.mdf' as DBFileName
,ldf.name+'.ldf' AS LogFileName
,mdf.physical_name AS DBFileFullName
,ldf.physical_name AS LogFileFullName
,d.dbstatus AS ExtendedStatus
FROM @helpdb d
JOIN sys.master_files mdf 
ON d.dbid1 = mdf.database_id and mdf.[type] = 0
JOIN sys.master_files ldf 
ON d.dbid1 = ldf.database_id and ldf.[type] = 1
JOIN sys.databases sdb
ON d.dbid1 = sdb.database_id
ORDER BY d.dbname;