TDS protocol capture

The ProtocolCapture connection string can be used to capture Tabular Data Stream™ (TDS) packets exchanged between an OLE DB application and the Server for debugging purposes. This property is enabled by specifying the capture file prefix.

ProtocolCapture takes effect immediately, so that (TDS) packets exchanged during connection establishment are written to a unique filename generated using the specified file prefix. (TDS) packets are written to the file for the duration of the connection. Use Ribo and other protocol translation tools to interpret the (TDS) capture files.

For example, ProtocolCapture="cap" results in the first connection generating cap0.tds, the second connection generates capt1.tds, and so forth.

NoteCaptured TDS protocol data saved to a file contains sensitive user authentication information and may contain confidential company or customer data. To protect this confidential data from unauthorized or accidental disclosure, the files containing captured data must be properly protected using file permissions or encryption.