Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management
Article ID: 311209 - View products that this article applies to.
This article was previously published under Q311209
This article includes script files that configure Microsoft SQL Server to support ASP.NET SQL Server mode session state management so that session data is persisted outside the tempdb database. This article includes information to download these alternative script files, which are named InstallPersistSqlState.sql and UninstallPersistSqlState.sql.
Note The downloadable scripts that are referenced in this article are only intended for use with the Microsoft .NET Framework 1.0. You must not use these scripts with the Microsoft .NET Framework 1.1 because the .NET Framework 1.1 does not support them. Use the persistent scripts that are supplied with the .NET Framework 1.1 instead when you develop applications by using the .NET Framework 1.1.
The persisting versions of the scripts (InstallPersistSqlState.sql and UninstallPersistSqlState.sql) resolve this problem by creating these tables in the ASPState database instead. Therefore, the session data is retained after you restart the computer that is running SQL Server.
To obtain the InstallPersistSqlState.sql and the UninstallPersistSqlState.sql files, download the PersistSqlState.exe self-extracting executable file. The following file is available for download from the Microsoft Download Center:
Release Date: April 23, 2002
Download PersistSqlState.exe now
Collapse this imageExpand this image
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
(http://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
For additional information about how to run default scripts that configure SQL Server for ASP.NET SQL Server mode session state management, click the article number below to view the article in the Microsoft Knowledge Base:
317604For additional information about the net start and the net stop commands, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/317604/EN-US/ )HOW TO: Configure SQL Server to Store ASP.NET Session State
236166For additional information about ASP.NET and ASP.NET state management, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/236166/EN-US/ )Using NET STOP and NET START Commands to Force IIS Services to Re-Read the Registry
(http://support.microsoft.com/kb/305140/EN-US/ )INFO: ASP.NET Roadmap
307598For more information about ASP.NET session state management, see the following article from the Nothin' but ASP.NET column on MSDN:
(http://support.microsoft.com/kb/307598/EN-US/ )INFO: ASP.NET State Management Overview
ASP.NET Session State
Article ID: 311209 - Last Review: March 27, 2007 - Revision: 6.9