Msg 5808, Level 16, State 1, Line 3
Ad hoc update to system catalogs is not supported.
when running (from LiteSpeed Maintenance Plan:
USE [database_name]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
WORKAROUND:
Run the following in Query Analyzer:
exec sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'allow updates', 0;
GO
RECONFIGURE WITH OVERRIDE;
GO
SQL Server has a setting called – “allow updates”. This setting was used in SQL Server 2000 to allow direct ad-hoc updates to system catalogs and tables. This setting is now deprecated since SQL Server 2005 and all SQL Server installations come with this set to 0 by default. Per Books On Line (read the BOL help on this option here), this setting has no effect, except that the RECONFIGURE statement will fail, just as it is doing in our case. Running the following statement to reset this back to 0 did the trick and I was now able to use RECONFIGURE again to reset the environment back to the “factory default”.
Also, see SOL46837
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center