APIs for SQLServer state storage

[Guest]

Hi,
Is there a set of APIs that would let me access the tables where ASP.NET
stores the state when in SQLServer mode.

Thanks.

Kishore

 

[DWinter]

I'm assuming you mean you are storing your session state in sql server and
not using a session server or inproc memory. If this is the case, then any
API you have to access a sql server database will do. Query Analyzer, or
even MS Access if you create a connection to the SQL database. Eventhough
the ASPState (or whatever you called it) that suppose to store the session
information appears it should be in that database, it is actually stored in
the tempdb. Look in the tempdb database of the server handling your session
state and you will find all your session data there.

D.

 

[Guest]

Storing the state in tempdb is fine, but you lose information when the
sqlserver is restarted. You can also store the state information in a
seperate database. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;311209