Ad Hoc Update to System Catalogs is not Supported in SQL Server 2012

This problem occurred when I was running the RECONFIGURE along with the "show advanced options and database mail xps" option through the sp_CONFIGURE to enable SQL Server Database Mail in SQL Server 2012. I got the following error. See the screenshot below.
 
 

Note - By default, SQL Server does not allow such ad-hoc updates to the system catalogs.

Solution - To resolve this issue, you have two options in SQL server

Option 1: you can use the "WITH OVERRIDE" option of the RECONFIGURE command and at this time it will be successful. See the screenshot below.
 
 
Option 2: Use this stored procedure sp_configure 'allow updates', 0

First, check the column- config_value of the "allow updates" configuration option. If it’s set to 1, change this value to 0, which is the default value,
 
 
Now, change the column -config_value value 1 to 0. See the screenshot below,
 
 
The problem has been resolved. You can see the screenshot given below,
 
Ebook Download
View all
Learn
View all