Error message when you run a maintenance plan after you set the "allow updates" option to 1 in SQL Server 2005: "Alter failed for server"

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.

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.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

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

1. In SQL Server Management Studio, run the following statement.

   sp_configure 'allow_updates', 1
   reconfigure with override

2. Run a maintenance plan.