Server-wide defaults

Table 2-3 indicates the default setting for each request capability by TDS version. A 1 indicates that the capability is supported in the TDS version. A 0 indicates that the capability is not supported.

Table 2-3: Request capabilities by TDS version

CS_REQUEST capability

4.0

4.0.2

4.2

4.6

5.0

CS_CAP_EXTENDEDFAILOVER

0

0

0

0

1

CS_CON_INBAND

0

0

0

0

1

CS_CON_OOB

1

1

1

1

0

CS_CSR_ABS

0

0

0

0

0

CS_CSR_FIRST

0

0

0

0

0

CS_CSR_LAST

0

0

0

0

0

CS_CSR_MULTI

0

0

0

0

0

CS_CSR_PREV

0

0

0

0

0

CS_CSR_REL

0

0

0

0

0

CS_DATA_BIN

1

1

1

1

1

CS_DATA_BIT

1

1

1

1

1

CS_DATA_BITN

0

0

0

0

0

CS_DATA_BOUNDARY

0

0

0

0

0

CS_DATA_CHAR

1

1

1

1

1

CS_DATA_DATE

0

0

0

0

1

CS_DATA_DATE4

0

0

1

1

1

CS_DATA_DATE8

1

1

1

1

1

CS_DATA_DATETIME

1

1

1

1

1

CS_DATA_DEC

0

0

0

0

0

CS_DATA_FLT4

0

0

1

1

1

CS_DATA_FLT8

1

1

1

1

1

CS_DATA_FLTN

1

1

1

1

1

CS_DATA_IMAGE

1

1

1

1

1

CS_DATA_INT1

1

1

1

1

1

CS_DATA_INT2

1

1

1

1

1

CS_DATA_INT4

1

1

1

1

1

CS_DATA_INT8

0

0

0

0

1

CS_DATA_INTN

1

1

1

1

1

CS_DATA_LBIN

0

0

0

0

0

CS_DATA_LCHAR

0

0

0

0

0

CS_DATA_MNY4

0

0

1

1

1

CS_DATA_MNY8

1

1

1

1

1

CS_DATA_MONEYN

1

1

1

1

1

CS_DATA_NUM

0

0

0

0

0

CS_DATA_SENSITIVITY

0

0

0

0

0

CS_DATA_TEXT

1

1

1

1

1

CS_DATA_TIME

0

0

0

0

1

CS_DATA_UCHAR

0

0

0

0

1

CS_DATA_UNITEXT

0

0

0

0

1

CS_DATA_VBIN

1

1

1

1

1

CS_DATA_VCHAR

1

1

1

1

1

CS_DATA_XML

0

0

0

0

1

CS_OPTION_GET

0

0

0

0

0

CS_PROTO_DYNAMIC

0

0

0

0

0

CS_PROTO_DYNPROC

0

0

0

0

0

CS_REQ_BCP

1

1

1

1

1

CS_REQ_CURSOR

0

0

0

0

0

CS_REQ_DBRPC2

0

0

0

0

1

CS_REQ_DYN

0

0

0

0

0

CS_REQ_LANG

1

1

1

1

1

CS_REQ_LARGEIDENT

0

0

0

0

1

CS_REQ_MIGRATE

0

0

0

0

1

CS_REQ_MSG

0

0

0

0

0

CS_REQ_MSTMT

0

0

0

0

0

CS_REQ_NOTIF

0

0

0

1

1

CS_REQ_PARAM

0

0

0

0

0

CS_REQ_RPC

1

1

1

1

1

CS_REQ_SRVPKTSIZE

0

0

0

0

1

CS_REQ_URGNOTIF

0

0

0

0

0

CS_WIDETABLES

0

0

0

0

1

Table 2-4 describes the default setting for each response capability by TDS version.

Table 2-4: Response capabilities by TDS version

CS_RESPONSE capability

4.0

4.0.2

4.2

4.6

5.0

CS_CON_NOINBAND

1

1

1

1

1

CS_CON_NOOOB

0

0

0

0

0

CS_DATA_NOBIN

0

0

0

0

0

CS_DATA_NOBIT

0

0

0

0

0

CS_DATA_NOBOUNDARY

1

1

1

1

1

CS_DATA_NOCHAR

0

0

0

0

0

CS_DATA_NODATE4

1

1

0

0

0

CS_DATA_NODATE8

0

0

0

0

0

CS_DATA_NODATETIME

0

0

0

0

0

CS_DATA_NODEC

1

1

1

1

1

CS_DATA_NOFLT4

1

1

0

0

0

CS_DATA_NOFLT8

0

0

0

0

0

CS_DATA_NOIMAGE

0

0

0

0

0

CS_DATA_NOINT1

0

0

0

0

0

CS_DATA_NOINT2

0

0

0

0

0

CS_DATA_NOINT4

0

0

0

0

0

CS_DATA_NOINT8

1

1

1

1

0

CS_DATA_NOINTN

0

0

0

0

0

CS_DATA_NOLBIN

1

1

1

1

1

CS_DATA_NOLCHAR

1

1

1

1

1

CS_DATA_NOMNY4

1

1

0

0

0

CS_DATA_NOMNY8

0

0

0

0

0

CS_DATA_NOMONEY

0

0

0

0

0

CS_DATA_NONUM

1

1

1

1

1

CS_DATA_NOSENSITIVITY

1

1

1

1

1

CS_DATA_NOSINT1

1

1

1

1

0

CS_DATA_NOTEXT

0

0

0

0

0

CS_DATA_NOUCHAR

1

1

1

1

0

CS_DATA_NOUNITEXT

1

1

1

1

0

CS_DATA_NOVBIN

0

0

0

0

0

CS_DATA_NOVCHAR

0

0

0

0

0

CS_DATA_NOXML

1

1

1

1

0

CS_RES_NOEED

1

1

1

1

1

CS_RES_NOMSG

1

1

1

1

1

CS_RES_NOPARAM

1

1

1

1

1

CS_RES_NOTDSDEBUG

1

1

1

1

1

CS_NO_LARGEIDENT

1

1

1

1

0

CS_NO_SRVPKTSIZE

1

1

1

1

0

CS_NOWIDETABLES

1

1

1

1

0