none
Please clarify COLMETADATA section in MS-TDS spec RRS feed

Answers

  • GENERAL UPDATE

    Your assessment about count “missing count of columns after the token type” is correct.
    It should be as shown below.

    COLMETADATA      =   TokenType
                                    Count
                                    NoMetaData / (1 *ColumnData)

    Also the size of the Flags parameter is always fixed at 16 bits regardless of the TDS version. Each of the 16 bits of the Flags parameter is interpreted based on the TDS version negotiated during login. For instance fSparseColumnSet bit has no meaning if TDS version is 7.2.

    To illustrate, I’ve added a colon followed by the number of bits required at the end of every field of FLAGS from TDS spec

    Flags        =   fNullable:1
                        fCaseSen:1
                        usUpdateable:2
                        fIdentity:1
                        (FRESERVEDBIT / fComputed):1
                        usReservedODBC:2
                        (FRESERVEDBIT / fFixedLenCLRType):1
                        (usReserved   / (FRESERVEDBIT fSparseColumnSet usReserved2)) :4
                        (FRESERVEDBIT / fHidden):1
                        (FRESERVEDBIT / fKey):1
                        (FRESERVEDBIT / fNullableUnknown):1

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Tuesday, January 5, 2016 10:38 PM
    Moderator

All replies

  • Hi Feroze,

    Thank you for your question. A member of the Protocol Documentation support team will respond to you soon.

    Regards,
    Vilmos Foltenyi - MSFT

    Monday, November 18, 2013 11:10 PM
  • Hello Feroze,
                       I am the engineer who will be working with you on this issue. I am currently researching the problem and will provide you with an update soon. Thank you for your patience.

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications

    Wednesday, November 20, 2013 2:32 PM
    Moderator
  • Wednesday, November 20, 2013 7:23 PM
  • Hello Feroze,

                        You can send the traces to dochelp at Microsoft dot com. Please mention "traces for colmetadata TDS" in the subject.

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications

    Friday, November 22, 2013 6:53 PM
    Moderator
  • GENERAL UPDATE

    Your assessment about count “missing count of columns after the token type” is correct.
    It should be as shown below.

    COLMETADATA      =   TokenType
                                    Count
                                    NoMetaData / (1 *ColumnData)

    Also the size of the Flags parameter is always fixed at 16 bits regardless of the TDS version. Each of the 16 bits of the Flags parameter is interpreted based on the TDS version negotiated during login. For instance fSparseColumnSet bit has no meaning if TDS version is 7.2.

    To illustrate, I’ve added a colon followed by the number of bits required at the end of every field of FLAGS from TDS spec

    Flags        =   fNullable:1
                        fCaseSen:1
                        usUpdateable:2
                        fIdentity:1
                        (FRESERVEDBIT / fComputed):1
                        usReservedODBC:2
                        (FRESERVEDBIT / fFixedLenCLRType):1
                        (usReserved   / (FRESERVEDBIT fSparseColumnSet usReserved2)) :4
                        (FRESERVEDBIT / fHidden):1
                        (FRESERVEDBIT / fKey):1
                        (FRESERVEDBIT / fNullableUnknown):1

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Tuesday, January 5, 2016 10:38 PM
    Moderator