-- this will get u started --

SET NOCOUNT ON

Create Table #t (

db varchar(255),

filename varchar(255),

name varchar(255),

int,

maxsize int,

growth int

)

Declare @db varchar(255)

Declare c Cursor

read_only

for

select name from sysdatabases where dbid > 4

Open c

fetch next from c into @db

while @@fetch_status = 0

begin

Exec ('INSERT #t

select ''' + @db + ''', filename, name, (size * 8)/1024, maxsize, growth

from' + @db + '..sysfiles

wherefileid = 1'

)

fetch next from c into @db

end

Close c

Deallocate c

Select * from #t

Drop table #t

edit math error... :blink: