Export (0) Print
Expand All

2.2.7.11 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 / ULONG;  (Changed to ULONG 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.<19>

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 will be 0.

 
Show:
© 2014 Microsoft