31/12/2014 by Nitesh

How To Remove Session Support from SQL Server

Friends, In this post we will see how can we remove Session State Support from SQL Server for ASP.Net applications. To completely remove the Session State support from SQL, we need to perform the following actions – Open Command Prompt Go to C:\Windows\Microsoft.Net\Framework\<Your Framework Version>\ Type aspnet_regsql -S SQLSERVER -U User -P Password -ssremove Confirm the question…

Continue Reading »

30/12/2014 by Nitesh

Generate SQL Script to Manage Session State in Custom SQL Database

Friends, ASP.Net provides 3 different ways to store sessions. They are – InProc Session Mode StateServer Session Mode SQL Server Session Mode In case you are interested to read further about sessions, you can read this excellent article by Abhijit Jana. In this post, we will see some specific details about SQL Server Session Mode….

Continue Reading »