• You could just use this

    EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "