Thank you. The vendor has decided to just not update the table in a separate statement. That seems to have done the trick.

We have found that at least some of them are table variables with the # and 8 hex digits. What we are looking at is the forward fetch number (received...

Believe me, I would love to change them to temp tables, but the stored procs are written by a 3rd party. We were able to find most of them checking...

It does not seem to go away.

The name in the tempDB database is not the same as the @table variable name. I tried SQL Search and it didn't return anything.