Could I be advised on creating and inserting /retrieving data from a temp table in .asp pages.<BR><BR>on page1.asp I created a temp table like this:...<BR>sql = "Create #MYTEMP_TABLE ....."<BR>THEN<BR>''created a connection object pointing to a database.:oConn<BR><BR>oConn.Execute sql<BR><BR>After this , I move to page2.asp, NO ERRORS OCCUR SO FAR.<BR><BR>But the moment I try to insert data in the temp table LIKE THIS:<BR>sql = "INSERT INTO MYTEMP_TABLE VALUES(....."<BR>''''Using same connection object : oConn<BR><BR>oConn.Execute<BR><BR>I get an error saying MYTEMP_TABLE IS NOT FOUND...<BR>What am i doing wrong?<BR>Are temp tables stored in some tempdb by default??? If yes, what would my connection string be??? What would be the path to the tempdb??<BR>I also read that temptables live as long as the session is alive.<BR>Does "session" mean the same thing as what we refer to as an ASP Session : Will the temptable be alive and active till the user is surfing thro' the website??