The other day we had an issue on SQL Server 2008 (10.0.4000) whereby a newly created maintenance plan was failing to execute.
Turned out this was due to the sp_configure value of "allow updates" having been set to 1.
To fix it we simply ran this sql statement and then set up the maintenance plan again...
sp_configure 'allow updates', 0
reconfigure
go
No comments:
Post a Comment