Article ID: 945067
Article Last Modified on 12/14/2007
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
SYMPTOMS
Consider the following scenario. In Microsoft SQL Server 2005, you set the allow updates option to 1. Then, you run a maintenance plan. In this scenario, you receive the following error message:
Additionally, the following error message is logged in the log file of the maintenance plan:
If you run a trace in SQL Server Profiler when this problem occurs, the following statement is captured in the SQL:BatchStarting event class and in the SQL:BatchCompleted event class.
EXEC sys.sp_configure N’user options’, 0 RECONFIGURE
RESOLUTION
To resolve this problem, set the allow updates option to 0 before you run a maintenance plan in SQL Server 2005.
To set the allow updates option to 0, run the following statement.
sp_configure 'allow updates', 0 reconfigure with override
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
The allow updates option is still present in the sp_configure stored procedure. However, if you set the allow updates option to 1, you cannot directly update the system tables. Additionally, direct updates to the system tables are not supported.
Steps to reproduce the problem
In SQL Server Management Studio, run the following statement.
sp_configure 'allow_updates', 1 reconfigure with override
- Run a maintenance plan.
Keywords: kbexpertiseadvanced kbtshoot kbprb KB945067