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.


Warnings 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. For more information about backup operations, see Backing Up and Restoring Databases.


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 Reporting Errors to Your Primary Support Provider
Backing Up and Restoring Databases Setting Configuration Options
Errors 1 - 999 sp_configure
osql Utility SQL Server Startup Options
RECONFIGURE  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.