Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: VB7
Expertise: Intermediate
Sep 1, 2003



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Persistent session state

In ASP.NET 1.0 you have the option to maintain the session state on an external process, in SQL Server, by setting the mode attribute of the sessionState tag in web.config to SQLServer. The problem is that the data is stored in the SQL Server's Temp database, and thus the data is lost if the SQL Server machine is rebooted. In ASP.NET 1.1 you can use a persistent database instead of Temp, and thus make the session state survive a reboot. To create the session tables in a new ASPState database, execute the InstallPersistSqlState.sql script that you find under the <Drive>:\systemroot\Microsoft.NET\Framework\version directory, instead of the InstallSqlState.sql you run under ASP.NET 1.0 (this script is still available, if you don't need persistent session state).

If you haven't upgrade to .NET Framework 1.1 yet, you can have persistent sessions anyway, by download the InstallPersistSqlState.sql and UninstallPersistSqlState.sql scripts from this MS KB article.

Marco Bellinaso
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date