Error 5852



Message text

Changing the value of '%s' is not allowed since it is a static option.


You can set or change the value of Adaptive Server configuration parameters in one of two ways:

Configuration parameters are either dynamic or static. Dynamic parameters go into effect as soon as you execute sp_configure. Static parameters, on the other hand, take effect only after Adaptive Server has been restarted. In version 12.5, several memory-related parameters were converted from static to dynamic.

NoteNot all parameters listed here may be available in your Adaptive Server version.

Error 5852 occurs when you run sp_configure with the read or verify option and Adaptive Server determines that you have changed the value of the static option mentioned in the error message and have not yet shut down and restarted Adaptive Server.


No action is required unless you want the value of the static parameter to be used now. If you do, shut down and restart Adaptive Server.

Additional information

Refer to “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for information about configuration parameters and options.

Versions in which this error is raised

All versions