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 |
send doneinproc tokens enables or disables Adaptive Server for sending doneinproc packets (TDS messages that are sent after each select statement performed in a stored procedure). send doneinproc tokens replaces dbcc tune ‘doneinproc’ and trace flag 292. Currently running queries immediately take note of any change in the option.
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.
