send doneinproc tokens

send doneinproc tokens enables or disables SAP ASE for sending doneinproc packets (these are TDS messages that are sent after various statements, in particular, non-select statements like insert, update, and so on).

Summary Information

Default value

1 (on)

Range of values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Network Communication

When disabled (set to 0), SAP ASE does not send doneinproc tokens for non-select statements.

send doneinproc tokens replaces dbcc tune ‘doneinproc’ and trace flag 292.

Setting send doneinproc tokens to 1 is safe in most cases. However, some stored procedures are executed using asynchronous commands from CT-Lib, and using a value of 0 may cause state-machine errors in some CT-Lib applications.