You are here:Home » tsql » "Ad hoc updates to system catalogs are not allowed" - SQL Server

"Ad hoc updates to system catalogs are not allowed" - SQL Server

While working with linked server as it was filed and giving error as linked server was failing. I think it may be the issue with the username or password on which the linked server communicate. To troubleshoot an issue I have tried to change the password, I got best common error.

That's it :  "Ad hoc updates to system catalogs are not allowed"


Now I was going to change the "Allow updates" from the configuration as follows, But another error was waiting for me.
"Ad hoc updates to system catalogs are not supported"



You can see here when I was running the first script, it has raised error, but after changing the script with Override option the statement was executed. What you think? Have you received any this type of error?