Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server Where Are ASPStateTempApplications and ASPStateTempSessions Tables?

Where Are ASPStateTempApplications and ASPStateTempSessions Tables?

ASPStateTempApplications and ASPStateTempSessions tables are in the TempDB database and are created when you configure SQL Server to Store ASP.NET Session State by running the InstallSqlState.sql script.

ASPStateTempApplications and ASPStateTempSessions Tables are located under tempdb (under System Databases)

Where Are ASPStateTempApplications and ASPStateTempSessions Tables

Where Are ASPStateTempApplications and ASPStateTempSessions Tables

1. ASPStateTempApplications

SqlSessionStateStore scopes data by application, so that multiple applications can store sessions in one session state database. To that end, the session state database contains an ASPStateTempApplications table that records application names and application IDs. Application names are not explicitly specified as they are for other providers; instead, SqlSessionStateStore uses the website’s IIS metabase path as the application name. Application IDs are hashes generated from application names by the stored procedure GetHashCode

2. ASPStateTempSessions

SqlSessionStateStore stores session data in the ASPStateTempSessions table of the session state database. Each record in ASPStateTempSessions holds the serialized session state for one session, and the auxiliary data that accompanies that session.

You should get more information from Session State Providers

I use those tables in order to verify whether ASP.NET sessions are stored in SQL Server session state database.

SELECT * FROM [tempdb].dbo.ASPStateTempApplications 
SELECT * FROM [tempdb].dbo.ASPStateTempSessions

SELECT * FROM [tempdb].dbo.ASPStateTempApplications SELECT * FROM [tempdb].dbo.ASPStateTempSessions

Query ASPStateTempApplications and ASPStateTempSessions Tables

Query ASPStateTempApplications and ASPStateTempSessions Tables

Feb 24, 2012Hoan Huynh
JavaScript Display Leaving Confirm Box Leave This Page Or Stay On This PageJavascript LTrim,RTrim,Trim function
You Might Also Like:
  • ASP.NET Store Session In MS SQL Server Database
  • PHP Store Session In MySQL Database
  • Fix session_start() open(/tmp) failed Permission Denied With .htaccess, ini_set and php.ini
  • Free Web Admin For Microsoft SQL Server And Oracle – 1ClickDBPro
  • Export/Import Data From Local Database To Remote Database With MS SQL Server 2008
  • PHP Connect To MS SQL Server
  • MySQL dump table
  • MSSQL Create Database With SQL Statement
  • Letter of resignation Example
  • Upgrading To .Net Framework 4 Makes Form Elements Become Undefinded Or Unavailable
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

10 years ago SQL ServerASPStateTempApplications, ASPStateTempSessions, InstallSqlState, TempDB3,006
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,459 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,839 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,655 views
JQuery Allow only numeric characters or only alphabet characters in textbox
14,994 views
C# Read Json From URL And Parse/Deserialize Json
11,722 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development