True distributed transaction support is only available for SQL Server 2000 and requires the installation of an external stored procedure in the target server (see the README. These benchmarks are free to download so we encourage you to do it and run them yourself.
The reason for this is to avoid Sybase "hangs" caused by running out of space with very large batches.
when using TDS 4.2 ) when connecting to any version of SQL Server as this is a Sybase specific protocol.
Currently j TDS automatically falls back from 8.0 to 7.0 (if used with SQL Server 7.0) and from 5.0 to 4.2 (with Sybase 10) so specifying the value for this parameter is only necessary for SQL Server 6.5.
Newer database server versions usually understand older protocol versions.
This means that SQL Server 7.0 can be used with TDS 4.2, but the limitations of the protocol apply regardless of the server version (e.g.