Create SQL table on Application_OnStart 1

[MikeCole]

I would like to know whether it is possible to create a temporary SQL table dynamically in database when ASP application starts.<br><br>I plan to execute table creation SQL command from Application_onStart in global.asa file.&nbsp;&nbsp;Then delete the table when Application_onEnd.&nbsp;&nbsp;The purpose of this table is to temporary store user inputted information without using ASP session or cookie variables.<br><br>Subsequently, insert user record by SessionID on Session_OnStart.&nbsp;&nbsp;&nbsp;And delete the user record on Session_OnEnd.&nbsp;&nbsp;&nbsp;<br><br>Has any one done this type of thingbefore ?<br>I would appreciate your feedback.<br><br>Thank-you<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

 

[palbano]

Dear Mike,<br><br>Never done it, but I can't think of any reason it should not work.<br><br>It might be simpler to just creat a table and delete each session row upon the Session_OnEnd though.<br><br>Good luck<br>-pete