.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 Mode work properly ?

Q

.NET INTERVIEW QUESTIONS - 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 “Tempdb”, you can configure it store outside “TempDB” by running Microsoft provided SQL script.

2009-06-09, 4115👍, 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