With Adaptive Server Enterprise ODBC Driver 15.7, Adaptive Server Enterprise OLE DB Provider 15.7, and Adaptive Server Enterprise ADO.NET Data Provider 15.7, you can use the SupressRowFormat2 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 the server sends reduced result set metadata when SupressRowFormat2 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.
0 – the default value; TDS_ROWFMT2 is not suppressed.
1 – forces the server to send data in TDS_ROWFMT where possible.