Use the SuppressRowFormat2 connection string property to force Adaptive Server to send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence. TDS_ROWFMT contains less data than TDS_ROWFMT2—which includes catalog, schema, table, and column information—and can result in better performance for many small select operations. Because Adaptive Server sends reduced result set metadata when SuppressRowFormat2 is set to 1, some information is not available to client programs. If your application relies on the missing metadata, you should not enable this property.
Values:
0 – the default value; forces Adaptive Server to send data in TDS_ROWFMT2 where possible.
1 – forces Adaptive Server to send data in TDS_ROWFMT where possible.
