For every database run

 Exec ('Use [' + @dbname + '] Exec sp_SpaceUsed @updateusage = ' + '''True''')

in your script before selecting size. 'True' updates the table size to the correct...