Hi!,

I would like to know the way to verify the existence of a temporary table created locally by the current session.

I've tried querying tempdb.dbo.sysobjects, but when I do so I get all the temporary tables for the different sessions.

e.g.

I have two sessions A and B, in session A, I create a table with tmpX for name. Now in session B I have some code manipulating a table with the same name, but I'd like to create the table just the first time the code is executed, next executions I'd just want to manipulate the existing table, but is in those cases when I can't find out if the table has been created in the current session.

Any help will be appreciated.

Thanks in advance!.