-
Title
Check DB Integrity task fails -
Description
Maintenance Plan fails when Check DB Integrity task is included.
Executed as user:<domain>\<username> Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 09:14:21 Progress: 2009-10-29 09:14:22.92 Source: {12EEEC63-BE26-4F58-8180-34464FB71C8B} Executing query DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp.: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:14:21 Finished: 09:14:24 Elapsed: 2.88 seconds. The package execution failed. The step failed.
-
Cause
The SQL Server option allow update has been changed from 0 to 1. This option allows modification in system tables of theSQL Server instancebut the reconfigure command issued by the Check DB Integrity task failed without the with override option.
-
Resolution
The allow update parameter should be set to 0 for this task to succeed.
-
Additional Information
The following message is issue by the GUI console logging: Configuration option user options changed from 0 to 0. Run the RECONFIGURE statement to install.