Revision Summary Date Revision History Revision Class Comments 3/14/2008 0.1 Major Initial Availability. 6/20/2008 0.1.1 Editorial Changed language and formatting in the technical content. 7/25/2008 0.1.2 Editorial Changed language and formatting in the technical content. 8/29/2008 0.1.3 Editorial Changed language and formatting in the technical content. 10/24/2008 0.1.4 Editorial Changed language and formatting in the technical content. 12/5/2008 0.2 Minor Clarified the meaning of the technical content. 1/16/2009 0.3 Minor Clarified the meaning of the technical content. 2/27/2009 0.4 Clarified the meaning of the technical content. 4/10/2009 0.5 Minor Clarified the meaning of the technical content.
5/22/2009 0.5.1 Editorial Changed language and formatting in the technical content. 7/2/2009 1.0 Major Updated and revised the technical content. 8/14/2009 1.1 Minor Clarified the meaning of the technical content. 9/25/2009 2.0 Major Updated and revised the technical content. 11/6/2009 3.0 Updated and revised the technical content. 12/18/2009 4.0 Major Updated and revised the technical content. 1/29/2010 4.1 Minor Clarified the meaning of the technical content. 3/12/2010 5.0 Major Updated and revised the technical content. 4/23/2010 6.0 Updated and revised the technical content. 6/4/2010 7.0 Updated and revised the technical content.
9/23/2011 11.0 Major Updated and revised the technical content. 12/16/2011 12.0 Major Updated and revised the technical content. 3/30/2012 12.1 Minor Clarified the meaning of the technical content. 7/12/2012 12.2 Minor Clarified the meaning of the technical content. 10/25/2012 12.2 None No changes to the meaning, language, or formatting of the technical content. 1/31/2013 13.0 Major Updated and revised the technical content. 8/8/2013 14.0 Major Updated and revised the technical content. 11/14/2013 15.0 Major Updated and revised the technical content. 2/13/2014 16.0 Major Updated and revised the technical content. 5/15/2014 17.0 Major Updated and revised the
technical content. 6/30/2015 18.0 Major Significantly changed the technical content. 10/16/2015 19.0 Major Significantly changed the technical content. 5/10/2016 19.0 None No changes to the meaning, language, or formatting of the technical content. 7/14/2016 19.0 None No changes to the meaning, language, or formatting of the technical content. 3/16/2017 20.0 Major Significantly changed the technical content. 6/1/2017 20.0 None No changes to the meaning, language, or formatting of the technical content. 8/16/2017 21.0 Major Significantly changed the technical content. 9/15/2017 22.0 Major Significantly changed the technical content.
20: Sends routing information to client Type Old Value New 1: Database OLDVALUE = B_VARCHAR NEWVALUE = B_VARCHAR 2: Language OLDVALUE = B_VARCHAR NEWVALUE = B_VARCHAR 3: Character Set OLDVALUE = B_VARCHAR NEWVALUE = B_VARCHAR 4: Packet Size OLDVALUE = B_VARCHAR NEWVALUE = B_VARCHAR 5: Unicode data sorting local id OLDVALUE = %x00 NEWVALUE = B_VARCHAR 6: Unicode data sorting comparison flags OLDVALUE = %x00 NEWVALUE = B_VARCHAR 7: SQL Collation OLDVALUE = B_VARBYTE NEWVALUE = B_VARBYTE 8: Begin Transaction OLDVALUE = %x00 NEWVALUE = B_VARBYTE 9: Commit Transaction OLDVALUE = B_VARBYTE NEWVALUE = "0x00" 10: Rollback Transaction OLDVALUE = B_VARBYTE NEWVALUE = %x00 11: Enlist DTC Transaction OLDVALUE = B_VARBYTE NEWVALUE = %x00 12: Defect Transaction OLDVALUE = %x00 NEWVALUE = B_VARBYTE 13: Database Mirroring Partner OLDVALUE = %x00 PARTNER_NODE = B_VARCHAR NEWVALUE = PARTNER_NODE 15: Promote Transaction OLDVALUE = %x00 DTC_TOKEN = L_VARBYTE; NEWVALUE = DTC_TOKEN
Index A Abstract data model client ( 112, 118) server ( 112, 126) ALL_HEADERS rule definition 32 33 33 15 18 156 178 26 C 15 186 Client abstract data model ( 112, 118) higher-layer triggered events ( 112, 120) initialization ( 112, 119) events ( 117, 125) message processing ( 112, 121) 125 124 121 124 124 121 123 123 122 messages 18 17 16 17 18 17 17 18 125 overview ( 112, 118) sequencing rules ( 112, 121) 125 124 121 124 124 121 123 123 122 timer events ( 117, 125) timers ( 112, 119) 16 131 D Data model - abstract client ( 112, 118) server ( 112, 126) Data stream types 30 30 30 Data type definitions 34 34 38 41 Table Valued Parameter 42 44 42 46 40 35 41 26 E 20 Examples 156 134 136 143 146 133 133 153 155 150 151 157 156 158 F 15 Final state ( 125, 132) 25 G 8 Grammar definition - token description 49 data stream 30 30 30 data type definitions 34 34 38
41 42 40 35 41 general rules 29 29 26 26 packet data stream headers 32 33 33 47 26 H Higher-layer triggered events client ( 112, 120) server ( 112, 127) I 179 179 20 11 127 Initialization client ( 112, 119) server ( 112, 127) 8 L Local events client ( 117, 125) server ( 117, 132) Logged In ( 124, 131) 128 134 136 143 146 M Message processing client ( 112, 121) 125 124 121 124 124 121 123 123 122 server ( 112, 127) 131 132 127 131 128 127 130 128 Messages 16 26 16 24 76 20 18 syntax 16 26 16 24 76 49 20 18 16 N 10 O Other local events 125 132 178 12 P 24 Packet data - stream definition 76 78 79 80 84 85 86 87 91 94 97 98 100 101 102 76 103 103 106 107 108 110 109 Packet data stream headers 32 33
33 24 76 Packet header message type - stream definition 50 49 166 171 52 63 67 161 71 71 176 72 159 Packets 20 23 packet header 23 21 23 23 22 21 23 20 179 14 133 14 180 Protocol Details 112 Q 33 R 10 11 10 14 18 153 155 S Security 179 179 179 179 178 124 124 121 123 123 122 Sequencing rules client ( 112, 121) 125 124 121 124 124 121 123 123 122 server ( 112, 127) 131 132 127 131 128 127 130 128 Server abstract data model ( 112, 126) higher-layer triggered events ( 112, 127) initialization ( 112, 127) local events ( 117, 132) message processing ( 112, 127) 131 132 127 131 128 127 130 128 messages 20 20 19 18 19 20 19 19 19 132 overview ( 112, 125) sequencing rules ( 112, 127) 131 132 127 131 128 127 130 128 timer events ( 117, 132) timers ( 112, 127) 18 130 178 150 151 17 17 157
156 15 Syntax client messages 18 17 16 17 18 17 17 18 grammar definition for token description 49 30 34 26 26 32 47 16 packet data token and tokenless data streams 26 24 25 178 24 packet data token stream definition 76 78 79 80 84 85 86 87 91 94 97 98 100 101 102 76 103 103 106 107 108 110 109 packet header message type - stream definition 50 49 166 171 52 63 67 161 71 71 176 72 159 159 packets 20 23 21 server messages 20 20 19 18 19 20 19 19 19 T events client ( 117, 125) server ( 117, 132) Timers client ( 112, 119) server ( 112, 127) 128 data stream 25 definition 25 25 26 25 25 Token data stream definition 76 78 79 80 84 85 86 87 91 94 97 98 100 101 102 76 103 103 106 107 108 110 109 Token data stream examples 178 178 178 Token description - grammar definition 49 data stream 30