Today I was working on Configuring Database Mail in SQL server 2005, I got an below SQL words
"Ad hoc update to system catalogs is not supported. (Microsoft SQL Server, Error: 5808)"
So to resolve this issue : You need to perform below steps to work around
Warning Incorrect modification of the system catalogs can result in database corruption or data loss as per BOL, Also we shouldn't not do anything to the system catalog without understanding the Impact before & after Implement.
"Ad hoc update to system catalogs is not supported. (Microsoft SQL Server, Error: 5808)"
So to resolve this issue : You need to perform below steps to work around
sp_configure 'allow updates', 0;
reconfigure; Warning Incorrect modification of the system catalogs can result in database corruption or data loss as per BOL, Also we shouldn't not do anything to the system catalog without understanding the Impact before & after Implement.
No comments:
Post a Comment