Buy Questpond's video subscriptions on
huge discount
.
Online: 1135
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
ASP.NET
>
Loading ...
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 : 1107 | Status :
[Member]
| Replies : 1
Write New Post
|
Search Forums
|
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
Login to post response
Latest Posts
Climax Delay Condoms for Long Lasting Pleasure
(0)
Iterating over columns of dataframe and print as rows in Python Django
(0)
Where can I found sample MVC projects to learn and improve skills
(1)
Extract a value from HTML string
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
More ...