Maintenance Plan Fails with the following
Databases: All databases
Include indexes
Task start: 2009-06-22T16:57:18.
Task end: 2009-06-22T16:57:19.
Failed:(0) Alter failed for Server
Various blogs tell you to alter the allow update configuration item ie:-
execute sp_configure 'allow updates', 1
reconfigure with override
This did not resolve the problem, but once it was altered back:-
execute sp_configure 'allow updates', 0
reconfigure with override
the job started to function correctly….go figure must be another bug!