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 |
