5 / 194
[MS-TDS] - v20150630
Tabular Data Stream Protocol
Copyright © 2015 Microsoft Corporation
Release: June 30, 2015
2.2.5.1.1 Least Significant Bit Order ................................................................ 29
2.2.5.1.2 Collation Rule Definition ................................................................... 30
2.2.5.2 Data Stream Types ............................................................................... 30
2.2.5.2.1 Unknown Length Data Streams ......................................................... 30
2.2.5.2.2 Variable-Length Data Streams .......................................................... 31
2.2.5.2.3 Data Type Dependent Data Streams .................................................. 31
2.2.5.3 Packet Data Stream Headers - ALL_HEADERS Rule Definition ..................... 33
2.2.5.3.1 Query Notifications Header ............................................................... 33
2.2.5.3.2 Transaction Descriptor Header .......................................................... 34
2.2.5.3.3 Trace Activity Header ....................................................................... 34
2.2.5.4 Data Type Definitions ............................................................................ 35
2.2.5.4.1 Fixed-Length Data Types .................................................................. 35
2.2.5.4.2 Variable-Length Data Types .............................................................. 36
2.2.5.4.3 Partially Length-Prefixed Data Types .................................................. 38
2.2.5.5 Data Type Details ................................................................................. 39
2.2.5.5.1 System Data Type Values ................................................................. 39
2.2.5.5.1.1 Integers ................................................................................... 39
2.2.5.5.1.2 Timestamp ................................................................................ 39
2.2.5.5.1.3 Character and Binary Strings ....................................................... 39
2.2.5.5.1.4 Fixed-Point Numbers .................................................................. 39
2.2.5.5.1.5 Floating-Point Numbers .............................................................. 40
2.2.5.5.1.6 Decimal/Numeric ....................................................................... 40
2.2.5.5.1.7 GUID ........................................................................................ 40
2.2.5.5.1.8 Date/Times ............................................................................... 40
2.2.5.5.2 Common Language Runtime (CLR) Instances ...................................... 41
2.2.5.5.3 XML Values ..................................................................................... 41
2.2.5.5.4 SQL_VARIANT Values ....................................................................... 42
2.2.5.5.5 Table Valued Parameter (TVP) Values ................................................ 43
2.2.5.5.5.1 Metadata .................................................................................. 43
2.2.5.5.5.2 Optional Metadata Tokens ........................................................... 45
2.2.5.5.5.3 TDS Type Restrictions ................................................................ 47
2.2.5.6 Type Info Rule Definition ........................................................................ 48
2.2.5.7 Encryption Key Rule Definition ................................................................ 49
2.2.5.8 Data Buffer Stream Tokens .................................................................... 50
2.2.6 Packet Header Message Type Stream Definition .............................................. 50
2.2.6.1 Bulk Load BCP ...................................................................................... 50
2.2.6.2 Bulk Load Update Text/Write Text ........................................................... 51
2.2.6.3 Federated Authentication Token .............................................................. 52
2.2.6.4 LOGIN7 ............................................................................................... 53
2.2.6.5 PRELOGIN ............................................................................................ 64
2.2.6.6 RPC Request......................................................................................... 68
2.2.6.7 SQLBatch ............................................................................................. 71
2.2.6.8 SSPI Message ....................................................................................... 72
2.2.6.9 Transaction Manager Request ................................................................. 72
2.2.7 Packet Data Token Stream Definition ............................................................ 76
2.2.7.1 ALTMETADATA ...................................................................................... 76
2.2.7.2 ALTROW .............................................................................................. 78
2.2.7.3 COLINFO .............................................................................................. 79
2.2.7.4 COLMETADATA ..................................................................................... 81
2.2.7.5 DONE .................................................................................................. 84
2.2.7.6 DONEINPROC ....................................................................................... 85
2.2.7.7 DONEPROC .......................................................................................... 86
2.2.7.8 ENVCHANGE ......................................................................................... 88
2.2.7.9 ERROR ................................................................................................. 91
2.2.7.10 FEATUREEXTACK .................................................................................. 94
2.2.7.11 FEDAUTHINFO ...................................................................................... 96
2.2.7.12 INFO ................................................................................................... 97
2.2.7.13 LOGINACK ........................................................................................... 98