Using a SQL DB for session state.

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default Using a SQL DB for session state.

    I have encountered a problem when I restart a SQL server I lose my session
    variables for ASP.NET

    It seems that the Temp table cannot be used after the re-boot ...

    Is there a way to fix this ?


    // Geri


    Geraldine Guest

  2. Similar Questions and Discussions

    1. Session state IIS (Machine Key | Load Balanced Session)
      This is a classic ASP group. Try microsoft.public.dotnet.framework.aspnet "Fred" <me@me.com> wrote in message...
    2. Session State
      Hi, I understand that there are 3 modes in which I can configure the SessionStateModule. What I need is an out of process Session State store...
    3. session state ???
      Hi, I have following function in a WebService-class : public int Count() { if ( null == Session ) Session = 0; else
    4. Asp Session state ??
      I'm pretty new to asp. It seems that I am assigning to the session rather than comparing against. I want to compare it in the first peice of code...
    5. Session state...
      Why are you calling a webservice that is within the same app. Shouldn't the web service be on a different server or at least be a different IIS...
  3. #2

    Default Using a SQL DB for session state.

    Geri,

    If you review the following microsoft article it details
    the scripts required to create a database to store the
    session state in. The default location for storing
    session is within temp db which is cleared out when you
    restart sql server.

    [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
    us;311209

    Hope this helps.

    Aidan
    >-----Original Message-----
    >I have encountered a problem when I restart a SQL server
    I lose my session
    >variables for ASP.NET
    >
    >It seems that the Temp table cannot be used after the re-
    boot ...
    >
    >Is there a way to fix this ?
    >
    >
    >// Geri
    >
    >
    >.
    >
    Aidan Glendye Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139