The issue had escalated to the point where we were seeing this over 600 times a day.

We had hundreds of workbooks and data connections that all used the same SQL...

We see this happen when executing a SELECT INTO with an OPENQUERY

[font="Courier New"]SELECT ... INTO tablename FROM OPENQUERY(linkedserver,'sql statement')....[/font]

The workaround we have found is to use a global temp table...

This was a great article.

I've used a similar albeit simpler table for logging at two different companies over the past 10 years. The log file has been very useful...