Here is how you can do it......

Truncate Table "Your Table"

Insert Into "Your Table"

Exec Master.Sys.SP_msforeachdb ' use [?]; exec sp_spaceused'

However, you will have to do as i did and modify the...