>>Maybe I'm having a brain freeze moment, but I could have sworn that when I did this inside of a .NET transaction years ago, it would work. Perhaps my memory is bad and I'm wrong. I'll try it again and will post again. Thanks.
>
>As far as I know, there are two kinds of temporary tables, like #table1 and ##table1
>Second will remain visible for connection, not the first.

The global temp table ##table1 will be visible to all connections, not the only one that created it as the #temp table.