Microsoft KB Archive/945067

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

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:

Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.

Additionally, the following error message is logged in the log file of the maintenance plan:

Failed:(0) Alter failed for server ' \\ '.

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 &quot;Applies to&quot; 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.