It's a shame that the OP didn't explain how they determined the table size.

You can get the information from this select-statement. It shows the size of the table and...

Has a consensus been reached and record = row?  I fear...

Calculating the amount of RAM used by a query isn't a very common question and so my curiosity has been piqued quite a bit.  Why did you need to know...

p.s.  To be sure, my intention is to make all of that "auto-magic" for Row-Store indexes.  I'm about 80% complete on that... as you know, the last 10-20% of something...

Interesting.

First, the original post on this thread was from 2.5 years ago.  I wonder if the OP ever resolved their problem.

The really interesting thing is that, although this is an...

Heh... as a bit of a sidebar, it's nice to see someone use the term "Record" correctly. 😀

This is a bit of a hunch but you might want to increasing the "LanMan" timeout in Windows.  We had a similar problem with remote backups that would work just...

Dunno for sure but my first guess is... is the user for the SQL Agent Service setup as an email user on your email system?

As a bit of a sidebar, this is why I jump through flaming hoops to ensure that we never use SSIS.  I've not had a problem avoiding it because most...

I'm in the process of trying to create one.  Some of it is rock solid and some of it is still a...

Ah... I thought you were just talking about the individual servers.

If both servers are at TLs 1.2, then I don't have have another idea (well, unless 1.0/1.1 is still "available"...

I have to ask, why do you think it's a problem to generate the error when the service is stopped?

Anyway, the one server that produces the error may have TLS...

Actually, I don't need to see anymore.

First of all is the fact that this report returns 70 MILLION rows.  To what end?  Who is going to read a 70 MILLION...

Heh... I'm not afraid of new technology... or change.  I'm afraid of the people that make them.

My concern is that a lot of it is either outright rubbish that takes...

I stored the HTML that you included as an HTML file and opened that with FireFox.  It came out looking like the following...