Revision Summary Date Revision History Revision Class Comments 3/14/2008 0.1 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 Clarified the meaning of the technical content. 1/16/2009 0.3 Clarified the meaning of the technical content. 2/27/2009 0.4 Minor 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 Clarified the meaning of the technical content. 9/25/2009 2.0 Major Updated and revised the technical content. 11/6/2009 3.0 Major 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 Major Updated and revised the technical content. 6/4/2010 7.0 Major Updated and revised the technical content.
7/16/2010 8.0 Major Updated and revised the technical content. 8/27/2010 8.0 None No changes to the meaning, language, or formatting of the technical content. 10/8/2010 9.0 Major Updated and revised the technical content. 11/19/2010 9.0 None No changes to the meaning, language, or formatting of the technical content. 1/7/2011 9.1 Clarified the meaning of the technical content. 2/11/2011 9.2 Minor Clarified the meaning of the technical content. 3/25/2011 9.3 Minor Clarified the meaning of the technical content. 5/6/2011 9.4 Minor Clarified the meaning of the technical content. 6/17/2011 10.0 Major Updated and revised the technical content.
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.
16: Transaction Manager Address<41> 17: Transaction ended 18: RESETCONNECTION/RESETCONNECTIONSKIPTRAN Completion Acknowledgement 19: back name of user instance started per login request 20: Sends routing information to client Type Old Value New Value 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 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
Index A Abstract data model client ( 111, 117) server ( 111, 125) ALL_HEADERS rule definition 32 32 33 15 18 155 177 26 C 15 185 Client abstract data model ( 111, 117) triggered events ( 111, 119) initialization ( 111, 118) local events ( 116, 124) message processing ( 111, 120) 124 123 120 123 123 120 122 122 121 messages 18 17 16 17 17 17 17 18 124 overview ( 111, 117) sequencing rules ( 111, 120) 124 123 120 123 123 120 122 122 121 timer events ( 116, 124) timers ( 111, 118) 16 130 D Data model - abstract client ( 111, 117) server ( 111, 125) Data stream types 30 29 30 Data type definitions 34 34 37 41 Table Valued Parameter 42 44 42 46 40 35 40 26 E 20 Examples 155 133 135 142 145 132 132 152 154 149 150 156 155 157 F 15 state ( 124, 131) 25 G 8 Grammar definition - token description 49 data stream types 30 29 30 data type definitions 34 34 37 41 42
40 35 40 general rules 29 28 26 26 packet data stream headers 32 32 33 47 26 H Higher-layer triggered events client ( 111, 119) server ( 111, 126) I 178 178 20 11 126 Initialization client ( 111, 118) server ( 111, 126) 8 L Local events client ( 116, 124) server ( 116, 131) Logged In state ( 123, 130) 127 133 135 142 145 M Message processing client ( 111, 120) 124 123 120 123 123 120 122 122 121 server ( 111, 126) 130 131 126 130 127 126 129 127 Messages 16 26 16 23 75 20 18 syntax 16 26 16 23 75 49 20 18 16 N 10 O Other local events 124 131 177 12 P 23 Packet data - token stream definition 75 78 79 80 83 84 86 87 91 93 97 98 99 101 101 75 102 103 105 106 108 109 109 Packet data stream headers 32 32 33 23
75 Packet header message type - stream definition 50 49 165 170 52 63 67 160 70 71 175 72 158 Packets 20 23 packet header 23 20 23 23 22 21 23 20 178 14 132 14 179 Protocol Details 111 Q 32 R 10 11 10 14 17 152 154 S Security 178 178 178 178 177 123 123 120 122 122 121 Sequencing rules client ( 111, 120) 124 123 120 123 123 120 122 122 121 server ( 111, 126) 130 131 126 130 127 126 129 127 Server abstract data model ( 111, 125) higher-layer triggered events ( 111, 126) initialization ( 111, 126) events ( 116, 131) message processing ( 111, 126) 130 131 126 130 127 126 129 127 messages 20 20 19 18 18 20 19 19 19 131 overview ( 111, 124) sequencing rules ( 111, 126) 130 131 126 130 127 126 129 127 timer events ( 116, 131) timers ( 111, 126) 18 129 177 149 150 17 17 156 155 15
Syntax client messages 18 17 16 17 17 17 17 18 grammar definition for token description 49 29 34 26 26 32 47 16 packet data token and tokenless data streams 26 23 24 177 24 packet data token stream definition 75 78 79 80 83 84 86 87 91 93 97 98 99 101 101 75 102 103 105 106 108 109 109 packet header message type - stream definition 50 49 165 170 52 63 67 160 70 71 175 72 158 158 packets 20 23 20 server messages 20 20 19 18 18 20 19 19 19 T Timer events client ( 116, 124) server ( 116, 131) Timers client ( 111, 118) server ( 111, 126) 127 Token data stream 24 token definition 25 24 26 25 25 Token data stream definition 75 78 79 80 83 84 86 87 91 93 97 98 99 101 101 75 102 103 105 106 108 109 109 Token data stream examples 177 177 177 Token description - grammar definition 49 data stream types 30 29 30