Error 259
Severity Level 16
Message Text
Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
Explanation
This error occurs when Microsoft® SQL Server™ detected an attempt to modify the system catalogs directly while the allow updates system configuration option of sp_configure is set to 0.
The allow updates system configuration option allows the system administrator to change the system catalogs directly.
Warning Severe problems can result from the direct manipulation of the system catalogs. Do not modify the system catalogs unless instructed to do so by your primary support provider.
Action
Before modifying any system catalogs, be sure that you have a valid backup of the database.
Warning Incorrect modification of the system catalogs can result in database corruption or data loss.
If possible, restart SQL Server in single-user mode by using the -m flag of the sqlservr application so that inadvertent modifications do not occur. For more information, see sqlservr Application.
To modify system catalogs, use the osql utility to alter the allow updates system configuration setting.
Note Only the system administrator can alter the value for the allow updates system configuration setting.
See Also
Backing Up and Restoring Databases