Share via


8 Index

A

Abstract data model

   client (section 3.1.1, section 3.2.1)

   server (section 3.1.1, section 3.3.1)

ALL_HEADERS rule definition

   overview

   Query Notifications header

   Transaction Descriptor header

Applicability

Attention message

Attention request example

Attention tokens

C

Capability negotiation

Change tracking

Client

   abstract data model (section 3.1.1, section 3.2.1)

   higher-layer triggered events (section 3.1.4, section 3.2.4)

   initialization (section 3.1.3, section 3.2.3)

   local events

   message processing (section 3.1.5, section 3.2.5)

      Final state

      Logged In state

      Sent Attention state

      Sent Client Request state

      Sent Initial PRELOGIN Packet state

      Sent LOGIN7 Record with SPNEGO Packet state

      Sent LOGIN7 Record with Standard Login state

      Sent TLS/SSL Negotiation Packet state

   messages

      Attention

      login

      overview

      pre-login

      remote procedure call

      SQL command

      SQL command with binary data

      transaction manager request

   other local events

   overview (section 3.1, section 3.2)

   sequencing rules (section 3.1.5, section 3.2.5)

      Final state

      Logged In state

      Sent Attention state

      Sent Client Request state

      Sent Initial PRELOGIN Packet state

      Sent LOGIN7 Record with SPNEGO Packet state

      Sent LOGIN7 Record with Standard Login state

      Sent TLS/SSL Negotiation Packet state

   timer events (section 3.1.6, section 3.2.6)

   timers (section 3.1.2, section 3.2.2)

Client Messages message

Client Request Execution state

D

Data model - abstract

   client (section 3.1.1, section 3.2.1)

   server (section 3.1.1, section 3.3.1)

Data stream types

   data type dependent data streams

   unknown-length data streams

   variable-length data streams

Data type definitions

   fixed-length data types

   overview

   partially length-prefixed data types

   SQL_VARIANT

   Table Valued Parameter

      metadata

      optional metadata tokens

      overview

      TDS type restrictions

   UDT Assembly Information

   variable-length data types

   XML data type

DONE tokens

E

Error messages

Examples

   attention request

   FeatureExt with AZURESQLSUPPORT Feature Data

   FeatureExt with SESSIONRECOVERY feature data

   FeatureExtAck with AZURESQLSUPPORT Feature Data

   FeatureExtAck with SESSIONRECOVERY feature data

   login request

   login request with federated authentication

   login response

   login response with federated authentication

   overview

   pre-login request

   RPC client request

   RPC server response

   SparseColumn select statement

   SQL batch client request

   SQL batch server response

   SQL command with binary data

   SSPI message

   Table response with SESSIONSTATE token data

   token data stream

      attention signal - out-of-band

      sending an SQL batch

   transaction manager request

   TVP insert statement

F

FeatureExt with AZURESQLSUPPORT Feature Data example

FeatureExt with SESSIONRECOVERY feature data example

FeatureExtAck with AZURESQLSUPPORT Feature Data example

FeatureExtAck with SESSIONRECOVERY feature data example

Fields - vendor-extensible

Final state (section 3.2.5.11, section 3.3.5.11)

Fixed-length token

G

Glossary

Grammar definition - token description

   data packet stream tokens

   data stream types

      data type dependent data streams

      unknown-length data streams

      variable-length data streams

   data type definitions

      fixed-length data types

      overview

      partially length-prefixed data types

      SQL_VARIANT

      Table Valued Parameter

      UDT Assembly Information

      variable-length data types

      XML data type

   general rules

      collation rule definition

      least significant bit order

      overview

   packet data stream headers

      overview

      Query Notifications header

      Transaction Descriptor header

   TYPE_INFO rule definition

Grammar Definition for Token Description message

H

Higher-layer triggered events

   client (section 3.1.4, section 3.2.4)

   server (section 3.1.4, section 3.3.4)

I

Implementer - security considerations

Index of security parameters

Informational messages

Informative references

Initial state

Initialization

   client (section 3.1.3, section 3.2.3)

   server (section 3.1.3, section 3.3.3)

Introduction

L

Local events

   client (section 3.1.7, section 3.2.7)

   server

Logged In state (section 3.2.5.7, section 3.3.5.8)

Login Ready state

Login request example

Login request with federated authentication example

Login response example

Login response with federated authentication example

M

Message processing

   client (section 3.1.5, section 3.2.5)

      Final state

      Logged In state

      Sent Attention state

      Sent Client Request state

      Sent Initial PRELOGIN Packet state

      Sent LOGIN7 Record with SPNEGO Packet state

      Sent LOGIN7 Record with Standard Login state

      Sent TLS/SSL Negotiation Packet state

   server (section 3.1.5, section 3.3.5)

      Client Request Execution state

      Final state

      Initial state

      Logged In state

      Login Ready state

      SPNEGO Negotiation state

      TLS/SSL Negotiation state

Messages

   Client Messages

   Grammar Definition for Token Description

   overview

   Packet Data Token and Tokenless Data Streams

   Packet Data Token Stream Definition

   Packets

   Server Messages

   syntax

      client messages

      grammar definition for token description

      overview

      packet data token and tokenless data streams

      packet data token stream definition

      packet header message type - stream definition

      packets

      server messages

   transport

N

Normative references

O

Other local events

   client

   server

Overview (synopsis)

P

Packet data - token stream definition

   ALTMETADATA

   ALTROW

   COLINFO

   COLMETADATA

   DONE

   DONEINPROC

   DONEPROC

   ENVCHANGE

   ERROR

   FEATUREEXTACK

   INFO

   LOGINACK

   NBCROW

   OFFSET

   ORDER

   RETURNSTATUS

   RETURNVALUE

   ROW

   SESSIONSTATE

   SSPI

   Table Valued Parameter row

   TABNAME

Packet data stream headers

   overview

   Query Notifications header

   Transaction Descriptor header

Packet Data Token and Tokenless Data Streams message

Packet Data Token Stream Definition message

Packet header message type - stream definition

   BulkLoad - UpdateText/WriteText

   BulkLoadBCP

   LOGIN7

   PRELOGIN

   RPCRequest

   SQLBatch

   SSPI message

   transaction manager request

Packets

   overview

   packet data

   packet header

      Length

      overview

      PacketID

      SPID

      Status

      Type

      Window

Packets message

Parameters - security index

Preconditions

Pre-login request example

Prerequisites

Product behavior

Protocol Details

   overview

Q

Query Notifications header

R

References

   informative

   normative

Relationship to other protocols

Remote procedure call

RPC client request example

RPC server response example

S

Security

   implementer considerations

   parameter index

Sent Attention state

Sent Client Request state

Sent Initial PRELOGIN Packet state

Sent LOGIN7 Record with SPNEGO Packet state

Sent LOGIN7 Record with Standard Login state

Sent TLS/SSL Negotiation Packet state

Sequencing rules

   client (section 3.1.5, section 3.2.5)

      Final state

      Logged In state

      Sent Attention state

      Sent Client Request state

      Sent Initial PRELOGIN Packet state

      Sent LOGIN7 Record with SPNEGO Packet state

      Sent LOGIN7 Record with Standard Login state

      Sent TLS/SSL Negotiation Packet state

   server (section 3.1.5, section 3.3.5)

      Client Request Execution state

      Final state

      Initial state

      Logged In state

      Login Ready state

      SPNEGO Negotiation state

      TLS/SSL Negotiation state

Server

   abstract data model (section 3.1.1, section 3.3.1)

   higher-layer triggered events (section 3.1.4, section 3.3.4)

   initialization (section 3.1.3, section 3.3.3)

   local events

   message processing (section 3.1.5, section 3.3.5)

      Client Request Execution state

      Final state

      Initial state

      Logged In state

      Login Ready state

      SPNEGO Negotiation state

      TLS/SSL Negotiation state

   messages

      attention acknowledgment

      error and informational messages

      login response

      overview

      pre-login response

      response completion

      return parameters

      return status

      row data

   other local events

   overview (section 3.1, section 3.3)

   sequencing rules (section 3.1.5, section 3.3.5)

      Client Request Execution state

      Final state

      Initial state

      Logged In state

      Login Ready state

      SPNEGO Negotiation state

      TLS/SSL Negotiation state

   timer events (section 3.1.6, section 3.3.6)

   timers (section 3.1.2, section 3.3.2)

Server Messages message

SparseColumn select statement example

SPNEGO Negotiation state

SQL batch client request example

SQL batch server response example

SQL command

SQL command with binary data

SQL command with binary data example

SSPI message example

Standards assignments

Syntax

   client messages

      Attention

      login

      overview

      pre-login

      remote procedure call

      SQL command

      SQL command with binary data

      transaction manager request

   grammar definition for token description

      data packet stream tokens

      data stream types

      data type definitions

      general rules

      overview

      packet data stream headers

      TYPE_INFO rule definition

   overview

   packet data token and tokenless data streams

      DONE and attention tokens

      overview

      token stream

      tokenless stream

   packet data token stream definition

      ALTMETADATA

      ALTROW

      COLINFO

      COLMETADATA

      DONE

      DONEINPROC

      DONEPROC

      ENVCHANGE

      ERROR

      FEATUREEXTACK

      INFO

      LOGINACK

      NBCROW

      OFFSET

      ORDER

      overview

      RETURNSTATUS

      RETURNVALUE

      ROW

      SESSIONSTATE

      SSPI

      Table Valued Parameter row

      TABNAME

   packet header message type - stream definition

      BulkLoad - UpdateText/WriteText

      BulkLoadBCP

      LOGIN7

      PRELOGIN

      RPCRequest

      SQLBatch

      SSPI message

      transaction manager request

   packets

      overview

      packet data

      packet header

   server messages

      attention acknowledgment

      error and informational messages

      login response

      overview

      pre-login response

      response completion

      return parameters

      return status

      row data

T

Table response with SESSIONSTATE token data example

Timer events

   client (section 3.1.6, section 3.2.6)

   server (section 3.1.6, section 3.3.6)

Timers

   client (section 3.1.2, section 3.2.2)

   server (section 3.1.2, section 3.3.2)

TLS/SSL Negotiation state

Token data stream

   overview

   token definition

      fixed-length token

      overview

      variable-count tokens

      variable-length tokens

      zero-length token

Token data stream definition

   ALTMETADATA

   ALTROW

   COLINFO

   COLMETADATA

   DONE

   DONEINPROC

   DONEPROC

   ENVCHANGE

   ERROR

   FEATUREEXTACK

   INFO

   LOGINACK

   NBCROW

   OFFSET

   ORDER

   overview

   RETURNSTATUS

   RETURNVALUE

   ROW

   SESSIONSTATE

   SSPI

   Table Valued Parameter row

   TABNAME

Token data stream examples

   out-of-band attention signal

   overview

   sending an SQL batch

Token description - grammar definition

   data packet stream tokens

   data stream types

      data type dependent data streams

      unknown-length data streams

      variable-length data streams

   data type definitions

      fixed-length data types

      overview

      partially length-prefixed data types

      SQL_VARIANT

      Table Valued Parameter

      UDT Assembly Information

      variable-length data types

      XML data type

   general rules

      collation rule definition

      least significant bit order

      overview

   overview

   packet data stream headers

      overview

      Query Notifications header

      Transaction Descriptor header

   TYPE_INFO rule definition

Tokenless data stream

Tracking changes

Transaction Descriptor header

Transaction manager request

Transaction manager request example

Transport

Triggered events - higher-layer

   client (section 3.1.4, section 3.2.4)

   server (section 3.1.4, section 3.3.4)

TVP insert statement example

U

Unknown-length data streams

V

Variable-count tokens

Variable-length data streams

Variable-length tokens

Vendor-extensible fields

Versioning

Z

Zero-length token