Export (0) Print
Expand All

4.17 FeatureExtAck with SessionRecovery Feature Data

A login response message that contains FeatureExt data for the SessionRecovery feature:

04 01 01 96 00 34 01 00 E3 1B 00 01 06 6D 00 61
00 73 00 74 00 65 00 72 00 06 6D 00 61 00 73 00
74 00 65 00 72 00 AB 58 00 45 16 00 00 02 00 25
00 43 00 68 00 61 00 6E 00 67 00 65 00 64 00 20
00 64 00 61 00 74 00 61 00 62 00 61 00 73 00 65
00 20 00 63 00 6F 00 6E 00 74 00 65 00 78 00 74
00 20 00 74 00 6F 00 20 00 27 00 6D 00 61 00 73
00 74 00 65 00 72 00 27 00 2E 00 00 00 00 00 00
00 E3 08 00 07 05 09 04 D0 00 34 00 E3 17 00 02
0A 75 00 73 00 5F 00 65 00 6E 00 67 00 6C 00 69
00 73 00 68 00 00 AB 5C 00 47 16 00 00 01 00 27
00 43 00 68 00 61 00 6E 00 67 00 65 00 64 00 20
00 6C 00 61 00 6E 00 67 00 75 00 61 00 67 00 65
00 20 00 73 00 65 00 74 00 74 00 69 00 6E 00 67
00 20 00 74 00 6F 00 20 00 75 00 73 00 5F 00 65
00 6E 00 67 00 6C 00 69 00 73 00 68 00 2E 00 00
00 00 00 00 00 AD 36 00 01 74 00 00 04 16 4D 00
69 00 63 00 72 00 6F 00 73 00 6F 00 66 00 74 00
20 00 53 00 51 00 4C 00 20 00 53 00 65 00 72 00
76 00 65 00 72 00 00 00 00 00 0B 00 08 C3 E3 13
00 04 04 34 00 30 00 39 00 36 00 04 34 00 30 00
39 00 36 00 AE 01 2E 00 00 00 00 09 00 60 81 14
FF E7 FF FF 00 02 02 07 01 04 01 00 05 04 FF FF
FF FF 06 01 00 07 01 02 08 08 00 00 00 00 00 00
00 00 09 04 28 23 00 00 FF FD 00 00 00 00 00 00
00 00 00 00 00 00

<tds version="latest">
  <BufferHeader>
    <Type>
      <BYTE>04 </BYTE>
    </Type>
    <Status>
      <BYTE>01 </BYTE>
    </Status>
    <Length>
      <BYTE>01 </BYTE>
      <BYTE>96 </BYTE>
    </Length>
    <SPID>
      <BYTE>00 </BYTE>
      <BYTE>00 </BYTE>
    </SPID>
    <Packet>
      <BYTE>01 </BYTE>
    </Packet>
    <Window>
      <BYTE>00 </BYTE>
    </Window>
  </BufferHeader>
  <BufferData>
    <TableResponse>
      <ENVCHANGE>
        <TokenType>
          <BYTE>E3 </BYTE>
        </TokenType>
        <Length>
          <USHORT>1B 00 </USHORT>
        </Length>
        <EnvChangeData>
          <BYTES>01 06 6D 00 61 00 73 00 74 00 65 00 72 00 06 6D 00 61 00 73 00 74 00 65 00 72 00 </BYTES>
        </EnvChangeData>
      </ENVCHANGE>
      <INFO>
        <TokenType>
          <BYTE>AB </BYTE>
        </TokenType>
        <Length>
          <USHORT>58 00 </USHORT>
        </Length>
        <Number>
          <LONG>45 16 00 00 </LONG>
        </Number>
        <State>
          <BYTE>02 </BYTE>
        </State>
        <Class>
          <BYTE>00 </BYTE>
        </Class>
        <MsgText>
          <US_UNICODE>
            <USHORTLEN>
              <USHORT>25 00 </USHORT>
            </USHORTLEN>
            <BYTES ascii="C.h.a.n.g.e.d. .d.a.t.a.b.a.s.e. .c.o.n.t.e.x.t. .t.o. .'.m.a.s.t.e.r.'...">43 00 68 00 61 00 6E 00 67 00 65 00 64 00 20 00 64 00 61 00 74 00 61 00 62 00 61 00 73 00 65 00 20 00 63 00 6F 00 6E 00 74 00 65 00 78 00 74 00 20 00 74 00 6F 00 20 00 27 00 6D 00 61 00 73 00 74 00 65 00 72 00 27 00 2E 00 </BYTES>
          </US_UNICODE>
        </MsgText>
        <ServerName>
          <B_UNICODE>
            <BYTELEN>
              <BYTE>00 </BYTE>
            </BYTELEN>
            <BYTES ascii="">
            </BYTES>
          </B_UNICODE>
        </ServerName>
        <ProcName>
          <B_UNICODE>
            <BYTELEN>
              <BYTE>00 </BYTE>
            </BYTELEN>
            <BYTES ascii="">
            </BYTES>
          </B_UNICODE>
        </ProcName>
        <LineNumber>
          <LONG>00 00 00 00 </LONG>
        </LineNumber>
      </INFO>
      <ENVCHANGE>
        <TokenType>
          <BYTE>E3 </BYTE>
        </TokenType>
        <Length>
          <USHORT>08 00 </USHORT>
        </Length>
        <EnvChangeData>
          <BYTES>07 05 09 04 D0 00 34 00 </BYTES>
        </EnvChangeData>
      </ENVCHANGE>
      <ENVCHANGE>
        <TokenType>
          <BYTE>E3 </BYTE>
        </TokenType>
        <Length>
          <USHORT>17 00 </USHORT>
        </Length>
        <EnvChangeData>
          <BYTES>02 0A 75 00 73 00 5F 00 65 00 6E 00 67 00 6C 00 69 00 73 00 68 00 00 </BYTES>
        </EnvChangeData>
      </ENVCHANGE>
      <INFO>
        <TokenType>
          <BYTE>AB </BYTE>
        </TokenType>
        <Length>
          <USHORT>5C 00 </USHORT>
        </Length>
        <Number>
          <LONG>47 16 00 00 </LONG>
        </Number>
        <State>
          <BYTE>01 </BYTE>
        </State>
        <Class>
          <BYTE>00 </BYTE>
        </Class>
        <MsgText>
          <US_UNICODE>
            <USHORTLEN>
              <USHORT>27 00 </USHORT>
            </USHORTLEN>
            <BYTES ascii="C.h.a.n.g.e.d. .l.a.n.g.u.a.g.e. .s.e.t.t.i.n.g. .t.o. .u.s._.e.n.g.l.i.s.h...">43 00 68 00 61 00 6E 00 67 00 65 00 64 00 20 00 6C 00 61 00 6E 00 67 00 75 00 61 00 67 00 65 00 20 00 73 00 65 00 74 00 74 00 69 00 6E 00 67 00 20 00 74 00 6F 00 20 00 75 00 73 00 5F 00 65 00 6E 00 67 00 6C 00 69 00 73 00 68 00 2E 00 </BYTES>
          </US_UNICODE>
        </MsgText>
        <ServerName>
          <B_UNICODE>
            <BYTELEN>
              <BYTE>00 </BYTE>
            </BYTELEN>
            <BYTES ascii="">
            </BYTES>
          </B_UNICODE>
        </ServerName>
        <ProcName>
          <B_UNICODE>
            <BYTELEN>
              <BYTE>00 </BYTE>
            </BYTELEN>
            <BYTES ascii="">
            </BYTES>
          </B_UNICODE>
        </ProcName>
        <LineNumber>
          <LONG>00 00 00 00 </LONG>
        </LineNumber>
      </INFO>
      <LOGINACK>
        <TokenType>
          <BYTE>AD </BYTE>
        </TokenType>
        <Length>
          <USHORT>36 00 </USHORT>
        </Length>
        <Interface>
          <BYTE>01 </BYTE>
        </Interface>
        <TDSVersion>
          <DWORD>FILTERED LATEST VERSION</DWORD>
        </TDSVersion>
        <ProgName>
          <B_UNICODE>
            <BYTELEN>
              <BYTE>16 </BYTE>
            </BYTELEN>
            <BYTES ascii="M.i.c.r.o.s.o.f.t. .S.Q.L. .S.e.r.v.e.r.....">4D 00 69 00 63 00 72 00 6F 00 73 00 6F 00 66 00 74 00 20 00 53 00 51 00 4C 00 20 00 53 00 65 00 72 00 76 00 65 00 72 00 00 00 00 00 </BYTES>
          </B_UNICODE>
        </ProgName>
        <ProgVersion>
          <DWORD>00 00 00 00 </DWORD>
        </ProgVersion>
      </LOGINACK>
      <ENVCHANGE>
        <TokenType>
          <BYTE>E3 </BYTE>
        </TokenType>
        <Length>
          <USHORT>13 00 </USHORT>
        </Length>
        <EnvChangeData>
          <BYTES>04 04 34 00 30 00 39 00 36 00 04 34 00 30 00 39 00 36 00 </BYTES>
        </EnvChangeData>
      </ENVCHANGE>
      <FEATUREEXTACK>
        <TokenType>
          <BYTE>AE </BYTE>
        </TokenType>
        <FeatureAckOpt>
          <FeatureId>
            <BYTE>01 </BYTE>
          </FeatureId>
          <FeatureAckDataLen>
            <DWORD>2E 00 00 00 </DWORD>
          </FeatureAckDataLen>
          <SessionStateDataSet>
            <SessionStateData>
              <StateId>
                <BYTE>00 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>09 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>00 60 81 14 FF E7 FF FF 00 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>02 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>02 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>07 01 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>04 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>01 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>00 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>05 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>04 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>FF FF FF FF </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>06 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>01 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>00 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>07 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>01 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>02 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>08 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>08 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>00 00 00 00 00 00 00 00 </BYTES>
              </StateValue>
            </SessionStateData>
            <SessionStateData>
              <StateId>
                <BYTE>09 </BYTE>
              </StateId>
              <StateLen>
                <BYTE>04 </BYTE>
              </StateLen>
              <StateValue>
                <BYTES>28 23 00 00 </BYTES>
              </StateValue>
            </SessionStateData>
          </SessionStateDataSet>
        </FeatureAckOpt>
        <FeatureAckOpt>
          <TERMINATOR>
            <BYTE>FF </BYTE>
          </TERMINATOR>
        </FeatureAckOpt>
      </FEATUREEXTACK>
      <DONE>
        <TokenType>
          <BYTE>FD </BYTE>
        </TokenType>
        <Status>
          <USHORT>00 00 </USHORT>
        </Status>
        <CurCmd>
          <USHORT>00 00 </USHORT>
        </CurCmd>
        <DoneRowCount>
          <LONGLONG>00 00 00 00 00 00 00 00 </LONGLONG>
        </DoneRowCount>
      </DONE>
    </TableResponse>
  </BufferData>
</tds>
 
Show:
© 2014 Microsoft