Error 259

Troubleshooting SQL Server

Troubleshooting

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

allow updates Option

Backing Up and Restoring Databases

Errors 1 - 999

osql Utility

RECONFIGURE

Reporting Errors to Your Primary Support Provider

Setting Configuration Options

sp_configure

Using Startup Options