quote:

---

DECLARE @SQL NVARCHAR(4000)
DECLARE @dbid INT
DECLARE @DBName SYSNAME

SET @dbid = 0

CREATE TABLE #tmpFileList
(
DB_File_Name nvarchar(100),
Size_MB decimal(10,2),
Used_MB decimal(10,2)
)

WHILE @dbid < (SELECT MAX(dbid) FROM master.dbo.sysdatabases)
BEGIN

SELECT TOP 1 @dbid = dbid, @DBName = name
FROM master.dbo.sysdatabases
WHERE dbid > @dbid
ORDER BY dbid

SET @SQL = 'INSERT INTO #tmpFileList ' +
'select [DB_File_Name] = convert(nvarchar(40),Name), [Size_MB] = convert(decimal(10,2),round(size/128.0000,2)), ' +
'[Used_MB] = convert(decimal(10,2), round(fileproperty(name,''SpaceUsed'')/128.0000,2)) '+
'from [' + @DBName + '].dbo.sysfiles order by fileid'
PRINT @SQL

EXEC sp_executesql @statement = @SQL
END

select * from #tmpFileList

drop table #tmpFileList

---