Specifies a limit to the amount of memory (in bytes) that can be allocated by processes spawned by the SCRIPT table operator.
Valid Range
The value can be zero or any positive integer that specifies the limit as a number of bytes.
When set to zero, the memory used is not limited.
Default
33,554,432 bytes (32 MB)
Related Information
For information on the SCRIPT table operator, see SQL Operators and User-Defined Functions, B035-1210.