An Ordinary Man

SQL Server Session Management Configure SQL Server for ASP.NET SQL Server Session State in Custom Database. To install the session state database on SQL Server, run Aspnet_regsql.exe tool supply the following information with the command: aspnet_regsql -ssadd -sstype c -d < Database> -S <Server> -U <Username> -P <Password> ·          The name of the Database, using –d option. ·          The name of the SQL Server instance, using the   -S   option. ·          The logon credentials for an account that has permission to create a database on a computer running SQL Server. Use the   -E   option to use the currently logged-on user, or use the   -U   option to specify a user ID along with the   -P   option to specify a password. ·          The   -ss...

Web is   stateless , which means a new instance of a web page class is re-created each time the page is posted to the server. As we all know, HTTP is a stateless protocol, it can't hold client information on a page. If the user inserts some information and move to the next page, that data will be lost and the user would not be able to retrieve that information. What do we need here? We need to store information. Session provides a facility to store information on server memory. It can support any type of object to store along with our own custom objects. For every client, session data is stored separately, which means session data is stored on a per client basis. State management using session is one of the best ASP.NET features, because it is secure, transparent from users, and we can store any kind of object in it. Along with these advantages, sometimes session can cause performance issues in high traffic sites because it is stored in server memory and clients read data fr...