Monday, July 26, 2004

VJs Tip Of The Day - July 26th 2004

Again Session State

Well this time we will get into little details... ASP.Net provides two pair of SQL scripts to create/delete the SQLServer Session DB... The first pair of script creates TempDB where ASP.Net session state is stored, but as the name specifies this DB will loose its value if SQL server is re-started...the script are named InstallSqlState.sql and UninstallSqlState.sql...

If you wish to keep your session data even more secure, you would do so by running the other pair of scripts... These scripts create permanent tables on SQL Server... These scripts are called InstallPersistSqlState.sql and UninstallPersistSqlState.sql... 

All the above mentioned scripts are located in the same folder as the session state NT service...

No comments: