TDS Protocol Versions meet client stacks

Developer hearted / Relational minded — Mon, 02 Mar 2009 12:59:32 GMT

A colleague (Cornel Sukalla) asked me what the protocol_version in sys.dm_exec_connections is all about.

re: Connection failure because of mismatched TDS version

SQL Protocols — Tue, 09 Jun 2009 09:31:21 GMT

Hi,

It's the negotiated TDS version in DWORD format. You can run the following to get the exact value:

select cast(protocol_version as varbinary(4)) from sys.dm_exec_connections

Thanks,

Xinwei