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.