locked
About TDS protocol version in SQL2008 RRS feed

  • Question

  • Hi guys,

    i need the exact version of tds (Tabular Data Stream) used in SQL2008 .

    I know that in SQL 2000 is TDSv7 but i don't know which is in SQL2008.

    Thanks in advance.

    Tuesday, October 19, 2010 3:50 PM

Answers

  • The highest TDS versions implemented by SQL Server 2008 are versions 7.3A and 7.3B. And, actually, SQL Server 2000 implements as high as TDS 7.1

    The official TDS protocol documentation can be found at http://msdn.microsoft.com/en-us/library/dd304523(PROT.13).aspx. If you refer to Appendix A of that documentation, there is a section on Product Behavior with a table detailing SQL Server versions as far back as 7.0 and their corresponding TDS versions.


    This post is provided 'as is' and confers no express or implied warranties or rights.
    • Marked as answer by Dan Benediktson Tuesday, October 19, 2010 9:20 PM
    • Unmarked as answer by Alter1974 Wednesday, October 20, 2010 8:09 AM
    • Marked as answer by Alter1974 Wednesday, October 20, 2010 8:09 AM
    Tuesday, October 19, 2010 9:20 PM