declare @freelogspace int
declare @countlogfiles int
declare @message varchar(4000)
declare @subject Varchar(100)
declare @nameoffile varchar(255)
declare @fileid int
declare @filepath varchar(255)
declare @sizefile int
declare @freespace int
declare @maxsize_file int
declare @growth int
declare @typegrowth varchar(5)
declare @usage varchar(14)
declare @dbuse varchar(50)
declare @chr_CR varchar(1)

set nocount on
select @dbuse=value from settings where settingname='DB'
select @chr_CR=value from settings where settingname='separator'
set @subject='databases_files'
exec ('use '+@dbuse +N' DBCC UPDATEUSAGE (0) WITH NO_INFOMSGS ')

create table #spaceinformation
(
nameoffile varchar(255),
fileid int,
filepath varchar(255),
sizefile int,
freespace int,
maxsize_file varchar(50),
growth int,
typegrowth varchar(5),
usage varchar(14),
)

CREATE TABLE #logspace (
DBName varchar( 100),
LogSize float,
PrcntUsed float,
status int
)


CREATE TABLE #dataspace
( FileID int,
FileGrp int,
TotExt int,
UsdExt int,
LFileNm varchar( 100),
PFileNm varchar( 100)
)


insert #spaceinformation
select name, fileid, filename,
'size' = convert(nvarchar(15), size * /1024,0,
'maxsize' = (case maxsize when -1 then 0
else
convert(nvarchar(15), maxsize * /1024 end),
'growth' = (case status & 0x100000 when 0x100000 then
convert(nvarchar(3), growth)
else
convert(nvarchar(15), growth * 8/1024) end),
'typegrows'=(case status & 0x100000 when 0x100000 then
'PRCNT'
else
'MB' end),
'usage' = (case status & 0x40 when 0x40 then 'log only' else 'data only' end)
from sysfiles
order by usage, size desc

select @countlogfiles=count(*) from #spaceinformation where usage='log only'

insert #dataspace
exec( 'dbcc showfilestats')

update #spaceinformation set freespace=(totext-usdext)*32/512
from #dataspace where #spaceinformation.fileid=#dataspace.fileid





INSERT INTO #logspace
EXEC ('DBCC sqlperf( logspace)')

select @freelogspace=convert(int,logsize*(100-prcntused)/100)/@countlogfiles from #logspace where dbname=@dbuse

update #spaceinformation set freespace=@freelogspace where usage='log only'
update #spaceinformation set usage='log' where usage='log only'
update #spaceinformation set usage='data' where usage='data only'


/* gathering data about files using cursor*/
declare look_over_files cursor for select * from #spaceinformation
open look_over_files
fetch look_over_files into @nameoffile,@fileid, @filepath, @sizefile, @freespace, @maxsize_file, @growth, @typegrowth, @usage
while @@fetch_status=0
begin
set @message=isnull(@message,'')+''''+convert(varchar(25),getdate(),120)+''', '''+@server_id+''', '''+@dbuse+''', '''+rtrim(@nameoffile)+''', '+convert(varchar,@fileid)+', '''+rtrim(@filepath)+''', '+convert(varchar,@sizefile)
+', '+convert(varchar,@freespace)+', '+convert(varchar,@maxsize_file)+', '+convert(varchar,@growth)+', '''+@typegrowth+''', '''+@usage+''', '''+substring(@filepath,1,1)+''''+@chr_CR+char(13)
fetch next from look_over_files into @nameoffile,@fileid, @filepath, @sizefile, @freespace, @maxsize_file, @growth, @typegrowth, @usage
end
deallocate look_over_files

drop table #spaceinformation
drop table #dataspace
drop table #logspace

процедурка собирает информацию о всех файлах базы данных, соответственно ты используй только необходимую часть её.
Рожи в скрипте смещные получились