470,570 Members | 2,252 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,570 developers. It's quick & easy.

Global Temp Table (with .NET)

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.

Sep 20 '08 #1
1 1373
1,017 Expert 512MB
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.
Sep 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by pb648174 | last post: by
reply views Thread by gwaddell | last post: by
2 posts views Thread by chettiar | last post: by
1 post views Thread by crazy_jutt | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.