>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.