Software QA (13)
SQL Server (1)
What are the precautions you will take in order that SQLSERVER
What are the precautions you will take in order that SQLSERVER Mode work properly ?
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 gTempdbh, you can configure it store outside gTempDBh 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, 4603👍, 0💬
.NET INTERVIEW QUESTIONS - What is Suspend and Resume in Threading ? It is Similar to Sleep and Inte...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
What is difference between Association, Aggregation and Inheritance relationships? In object oriente...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...