OK, I got that working but I now have another issue. The new proc can run from any database but returns results only from the master database. Like this statement in the proc returns master db info: Its looking at sysfiles in master not my database.
select sum(convert(dec(15,2),size))
from dbo.sysfiles
where (status & 64 = 0)
Darren
Darren