OnDoc
| sign
in
up
~
pub
|
pdf
txt
html
toc
url
|
<<
>>
1
2
3
4
5
6
7
8
~
110
Table of Contents
Contents
1 Introduction
1.1 Glossary
1.2 References
1.2.1 Normative References
1.2.2 Informative References
1.3 Overview
1.4 Relationship to Other Protocols
1.5 Prerequisites/Preconditions
1.6 Applicability Statement
1.7 Versioning and Capability Negotiation
1.8 Vendor-Extensible Fields
1.9 Standards Assignments
2 Messages
2.1 Transport
2.2 Message Syntax
2.2.1 Client Messages
2.2.1.1 Pre-Login
2.2.1.2 Login
2.2.1.3 SQL Batch
2.2.1.4 Bulk Load
2.2.1.5 Remote Procedure Call
2.2.1.6 Attention
2.2.1.7 Transaction Manager Request
2.2.2 Server Messages
2.2.2.1 Pre-Login Response
2.2.2.2 Login Response
2.2.2.3 Row Data
2.2.2.4 Return Status
2.2.2.5 Return Parameters
2.2.2.6 Response Completion (DONE)
2.2.2.7 Error and Info Messages
2.2.2.8 Attention Acknowledgment
2.2.3 Packets
2.2.3.1 Packet Header
2.2.3.1.1 Type
2.2.3.1.2 Status
2.2.3.1.3 Length
2.2.3.1.4 SPID
2.2.3.1.5 PacketID
2.2.3.1.6 Window
2.2.3.2 Packet Data
2.2.4 Packet Data Token and Tokenless Data Streams
2.2.4.1 Tokenless Stream
2.2.4.2 Token Stream
2.2.4.2.1 Token Definition
2.2.4.2.1.1 Zero-Length Token (xx01xxxx)
2.2.4.2.1.2 Fixed-Length Token (xx11xxxx)
2.2.4.2.1.3 Variable-Length Token (xx10xxxx)
2.2.4.3 DONE and Attention Tokens
2.2.4.4 Token Stream Examples
2.2.4.4.1 Sending a SQL Batch
2.2.4.4.2 Out-of-Band Attention Signal
2.2.5 Grammar Definition for Token Description
2.2.5.1 General Rules
2.2.5.1.1 Least Significant Bit Order
2.2.5.2 Data Stream Types
2.2.5.2.1 Unknown-Length Data Streams
2.2.5.2.2 Variable-Length Data Streams
2.2.5.2.3 Data-Type-Dependent Data Streams
2.2.5.3 Data Type Definitions
2.2.5.3.1 Fixed-Length Data Types
2.2.5.3.2 Variable-Length Data Types
2.2.5.4 Data Type Details
2.2.5.4.1 System Data Type Values
2.2.5.4.1.1 Integers
2.2.5.4.1.2 Timestamp
2.2.5.4.1.3 Character and Binary Strings
2.2.5.4.1.4 Fixed-Point Numbers
2.2.5.4.1.5 Floating-Point Numbers
2.2.5.4.1.6 Decimal/Numeric
2.2.5.4.1.7 GUID
2.2.5.4.1.8 Date/Times
2.2.5.5 Type Info Rule Definition
2.2.5.6 Data Buffer Stream Tokens
2.2.6 Packet Header Message Type Stream Definition
2.2.6.1 Bulk Load BCP
2.2.6.2 Bulk Load Update Text/Write Text
2.2.6.3 LOGIN
2.2.6.4 PRELOGIN
2.2.6.5 RPC Request
2.2.6.6 SQLBatch
2.2.6.7 SSPI Message
2.2.6.8 Transaction Manager Request
2.2.7 Packet Data Token Stream Definition
2.2.7.1 ALTFMT
2.2.7.2 ALTNAME
2.2.7.3 ALTROW
2.2.7.4 COLINFO
2.2.7.5 COLFMT
2.2.7.6 COLNAME
2.2.7.7 DONE
2.2.7.8 DONEINPROC
2.2.7.9 DONEPROC
2.2.7.10 ENVCHANGE
2.2.7.11 ERROR
2.2.7.12 INFO
2.2.7.13 LOGINACK
2.2.7.14 OFFSET
2.2.7.15 ORDER
2.2.7.16 RETURNSTATUS
2.2.7.17 RETURNVALUE
2.2.7.18 ROW
2.2.7.19 SSPI
2.2.7.20 TABNAME
2.3 Directory Service Schema Elements
3 Protocol Details
3.1 Common Details
3.1.1 Abstract Data Model
3.1.2 Timers
3.1.3 Initialization
3.1.4 Higher-Layer Triggered Events
3.1.5 Message Processing Events and Sequencing Rules
3.1.6 Timer Events
3.1.7 Other Local Events
3.2 Client Details
3.2.1 Abstract Data Model
3.2.2 Timers
3.2.3 Initialization
3.2.4 Higher-Layer Triggered Events
3.2.5 Message Processing Events and Sequencing Rules
3.2.5.1 Sent Initial PRELOGIN Packet State
3.2.5.2 Sent TLS/SSL Negotiation Packet State
3.2.5.3 Sent LOGIN Record State
3.2.5.4 Sent SSPI Record with SPNEGO Packet State
3.2.5.5 Logged In State
3.2.5.6 Sent Client Request State
3.2.5.7 Sent Attention State
3.2.5.8 Final State
3.2.6 Timer Events
3.2.7 Other Local Events
3.3 Server Details
3.3.1 Abstract Data Model
3.3.2 Timers
3.3.3 Initialization
3.3.4 Higher-Layer Triggered Events
3.3.5 Message Processing Events and Sequencing Rules
3.3.5.1 Initial State
3.3.5.2 TLS/SSL Negotiation
3.3.5.3 Login Ready
3.3.5.4 SPNEGO Negotiation
3.3.5.5 Logged In
3.3.5.6 Client Request Execution
3.3.5.7 Final State
3.3.6 Timer Events
3.3.7 Other Local Events
4 Protocol Examples
4.1 Pre-Login Request
4.2 Login Request
4.3 Login Response
4.4 SQL Batch Client Request
4.5 SQL Batch Server Response
4.6 RPC Client Request
4.7 RPC Server Response
4.8 Attention Request
4.9 SSPI Message
4.10 Bulk Load
4.11 Transaction Manager Request
5 Security
5.1 Security Considerations for Implementers
5.2 Index of Security Parameters
6 Appendix A: Product Behavior
7 Change Tracking
8 Index