Is it possible to get the value of the session from sql server ?

yes you need to set session state mode as SQLSERVER

<configuration>
   <system.web>
      <sessionState mode="SQLServer"
        sqlConnectionString="data source= ServerName;
        user id=User;password=Password"
        cookieless="true"
        timeout="20" />
   </system.web>
</configuration>

http://support.microsoft.com/kb/323262
Satalaj

Dear Satalaj ,

Im sorry that maybe my question wasnt clear enough
what i realy want to ask is :
how can i get the value of the session which is still alive on the server.

for example in my webapplication have a session called session("username")
than how can i get all session("username") of the client that currently using my webapp

correct me if im wrong, isnt it if youre using session state mode as SQLSERVER
the session value were stored at the sql server ??

all ican see in my database were only two tables ASPStateTempSessions, ASPStateTempApplications
and i dont know what the use of those tables

Thanks :)

anyone ?