My maintenance plan integrity
check task was failing with "Alter failed for server XXX".
After tracing i found the maintenance plan executes sp_configure 'USER OPTIONS',xxxx followed by RECONFIGURE. The reconfigure statement then generates an error causing the plan to fail. This was because the server configuration option "Allow Updates" was set to 1. Changed the setting back to 0 and the reconfigure statement started to work again!
After tracing i found the maintenance plan executes sp_configure 'USER OPTIONS',xxxx followed by RECONFIGURE. The reconfigure statement then generates an error causing the plan to fail. This was because the server configuration option "Allow Updates" was set to 1. Changed the setting back to 0 and the reconfigure statement started to work again!
Following command changes
"Allow Updates" parameter to "0"
SP_CONFIGURE 'ALLOW UPDATES',0
GO
RECONFIGURE
GO
GO
RECONFIGURE
GO
No comments:
Post a Comment