To set the language in cache optionUse the language in cache option to specify the maximum number of languages that can be held simultaneously in the language cache. The default is 3.
The setting takes effect after stopping and restarting the server.
To set the language in cache option
| RECONFIGURE | sp_configure |
| Setting Configuration Options |