Using SQl Server to do the viewstate
Configure SQL Server to Store ASP.NET Session State
http://support.microsoft.com/kb/317604
| 1. | In SQL Query Analyzer, on the File menu, click Open. |
| 2. | In the Open Query File dialog box, browse to the InstallSqlState.sql script file, and then click Open. By default, InstallSqlState.sql is located in one of the following folders: system drive\WINNT\Microsoft.NET\Framework\version\
system drive\Windows\Microsoft.NET\Framework\version\ |
| 3. | After InstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script. |
| 4. | Before you run the UninstallSqlState.sql script file to uninstall SQL Server mode session state management configuration, you must stop the w3svc process. To do this, follow these steps: | a. | On the Windows Start menu, click Run, type cmd, and then click OK to open a command prompt. | | b. | At the command prompt, type net stop w3svc. You receive confirmation that the w3svc process is stopped. |
|
| 5. | In SQL Query Analyzer, on the File menu, click Open. |
| 6. | In the Open Query File dialog box, browse to the UninstallSqlState.sql script file, and then click Open. By default, UninstallSqlState.sql is located in one of the following folders: system drive\WINNT\Microsoft.NET\Framework\version\
system drive\Windows\Microsoft.NET\Framework\version\ |
| 7. | After UninstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script. |
| 8. | After you uninstall SQL Server mode session state management configuration, you must restart the w3svc service. To restart the w3svc process, type net start w3svc at a command prompt. |