.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

What are the precautions you will take in order that SQLSERVER

Q

What are the precautions you will take in order that SQLSERVER Mode work properly ?

✍: Guest

A

Following are the things to remember so that SQLSERVER Mode works properly :-

ã SQLSERVER mode session data is stored in a different process so you must ensure that your objects are serializable.
ã IIS metabase (\LM\W3SVC\2) must be identical across all servers in that farm.
ã By default Session objects are stored in gTempdbh, you can configure it store outside gTempDBh by running Microsoft provided SQL script.

Note :- “TempDB” database is re-created after SQL SERVER computer reboot.If you want to maintain session state with every reboot best is to run SQL Script and store session objects outside “TempDB” database.

2007-10-23, 5185👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML