2.2.7.13 INFO

Token Stream Name:

 INFO

Token Stream Function:

Used to send an information message to the client.

Token Stream Comments

  • The token value is 0xAB.

Token Stream-Specific Rules:

 TokenType        =   BYTE
 Length           =   USHORT
 Number           =   LONG
 State            =   BYTE
 Class            =   BYTE
 MsgText          =   US_VARCHAR
 ServerName       =   B_VARCHAR
 ProcName         =   B_VARCHAR
 LineNumber       =   USHORT / LONG;  (Changed to LONG in TDS 7.2)

The type of the LineNumber element depends on the version of TDS.

Token Stream Definition:

 INFO             =   TokenType
                      Length
                      Number
                      State
                      Class
                      MsgText
                      ServerName
                      ProcName
                      LineNumber

Token Stream Parameter Details

 Parameter

 Description

TokenType

INFO_TOKEN

Length

The total length of the INFO data stream, in bytes.

Number

The info number.<64>

State

The error state, used as a modifier to the info Number.

Class

The class (severity) of the error. A class of less than 10 indicates an informational message.

MsgText

The message text length and message text using US_VARCHAR format.

ServerName

The server name length and server name using B_VARCHAR format.

ProcName

The stored procedure name length and stored procedure name using B_VARCHAR format.

LineNumber

The line number in the SQL batch or stored procedure that caused the error. Line numbers begin at 1; therefore, if the line number is not applicable to the message as determined by the upper layer, the value of LineNumber is 0.