In which table the session is stored, when we write session state mode as sql server?

Posted by Shreedar under ASP.NET on 8/26/2015 | Points: 10 | Views : 900 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

Regards

Sridhar Thota.
www.dotnet-sridhar.blogspot.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Key123 on: 9/3/2015 [Member] Starter | Points: 25

0	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 http://www.developer.com/net/asp/article.php/3595766/Storing-Session-State-in-a-SQL-Server-Database.htm -Tanya Shreedar, if this helps please login to Mark As Answer. \| Alert Moderator

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 http://www.developer.com/net/asp/article.php/3595766/Storing-Session-State-in-a-SQL-Server-Database.htm

-Tanya

Shreedar, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts