I've been able to get the local temporary table name from sysobjects, but I still can't select from it.
for example, the following select statement won't work
select * from #temptable_____00015
It says invalid object name.
I've even stored the temp table name in a variable and tryed to execute dynamic sql to get to it--no luck.
I need this technique to handle two support situations: A user freezes during data entry to a temp table, I want to capture the data before they reboot, so they don't have to reenter.
Temp tables are used among several stored procedures and then crunched into other tables. I'm getting incorrect results and want to see the raw data in the temp tables to assist me in figuring out what's going on.