Summary information |
|
|---|---|
Default value |
1 |
Range of values |
0 - 1 |
Status |
dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
|
‘send doneinproc tokens’ is a persistent tuning option for ‘doneinproc’. This configuration option replaces earlier dbcc tune option ‘doneinproc’ and the trace flag 292. Any queries currently running will immediately take note of any change in the option.
1> sp_config 'send doneinproc tokens' 2> go
Using the value of 1 is safe in most cases, however care should be taken for cases where sprocs are executed using asynchronous commands from ct-lib. Using the value of 0 may cause state-machine errors in some ct-lib applications.
Changing the default configuration for this option must
be done withh care since the ‘doneinproc’ tokens
are crucial to the ct-lib and db-lib based client behavior.
