• notice
  • Congratulations on the launch of the Sought Tech site

How to view TDS packet content in SSMS

To view the contents of the TDS database in detail, we can:

Use the NETWORK MONITOR tool to monitor the contents of the TDS data packet

Or turn on the trace flag 4052, 4055, 3605, then SQLSERVER will receive and send TDS data packets in

Displayed in SQLSERVER error log.Enabling these trace flags will have an impact on performance, so they can only be turned on in a test environment.

Use the following command line to start the database, and then run the above ADO VBScript script to view the database version

sqlservr.exe -c -skatmai -T4052 -T4055 -T3605

You can’t use the command line, you can only use the GUI.You must stop SQLSERVER before adding it to add startup parameters.After adding it, restart SQL and you can see the received TDS packets

You can only add one line at a time

You can see the following TDS packets in the sqlserver error log.Here, each byte of the TDS packet has its specific meaning.

If the first byte of the received packet is 01, it means that the command received by SQL is a SQL Batch command, and the second 01 represents the status of the TDS packet

28 represents the length of the TDS packet.For the specific meaning of each byte, readers can refer to the TDS specification



Technical otaku

Sought technology together

Related Topic


Leave a Reply