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