Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
In which table the session is stored, when we write session state mode as sql server?
on 8/26/2015 |
| Views : 426 | Status :
| Replies : 1
Write New Post
Un Answered Posts
While using session state, if we mention session state mode=sqlserver,
where does this will get store in sql server? How to see that value?
Reply with Attachment
We need configure for saving session in sqlserver. This configuration is done using ASPNET_REGSQL.EXE.
we can store the session state in three possible locations within the SQL Server:
Temporary storage: the session state is stored in the "tempdb" database of SQL Server. The ASPNET_REGSQL.EXE creates a database called ASPState and adds certain stored procedures for managing session to it. The tool also creates required tables in the "tempdb" database. If you restart the SQL server, the session data is not persisted.
Persistent storage: The tooASPNET_REGSQL.EXE creates a database called ASPState and adds stored procedures for managing a session to it. The session state is stored in the ASPState database. The data is persisted even if you restart the SQL server.
Custom storage: Both the session state data and the stored procedures are stored in a custom database.
The database name must be specified in the configuration file.
Further info: Refer
, if this helps please
Mark As Answer
Login to post response
Information on Dot net Platform
SSRS report through C#.
Build the application time get the below error
How to close the respective modal dialog when switch over to other modal dialog without overlapping
how to save and use variable in jquery
How to add Parameterized Image in RDLC report?
How to Solve this Hosting Issues.
How do i get payment status in redirect page using bitpay?