Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE:
“Ad hoc update to system catalogs is not supported.”
EXPLANATION:
If the “allow updates” option in SQL Server Instance is enabled, you receive this error when you run the following sample code.
1 2 3 4 | sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE GO |
SOLUTION:
If you want to leave ‘allow updates’ enabled, then type the code as follows:
1 2 3 4 | sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE WITH OVERRIDE GO |
If you disable the ‘allow updates’ option using the sp_configure Stored Procedure, you can run the first code without error:
1 2 3 4 | sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE GO |
