Global Temp Table (with .NET)

[romV]

Hi,
I have a procedure that creates the global temp table (##temp) inside a procedure which is populated with data when it is run for the first time. And when the procedure is executed second time, it uses that temp table instead of loading it all over.

The trouble I am having is that when I execute the procedure from Asp.NET the temp table stays there as long as i call the same procedure, but as soon as I call another procedure the temp table gets deleted even if I use the same object to execute the procedure.

Hope someone can help me in this. I dont know what is happening in here, I am lost.

Thanks In advance, hope to hear from you guys soon.

cheers.

[iburyak]

Global temp table stays in memory for as long as at least one connection is opened to it. If you create a table and disconnect and another connection tries to read data from the same table but a little later table is already out of scope or no longer exists.

Hope it explained your problem.
Create a permanent table and just empty or reload it whenever needed.

Good Luck.