Ad hoc update to system catalogs is not supported
While preparing the demo for my previous post “Optimize for ad hoc workloads – SQL 2008“, I encountered an issue and that’s the topic for this blog. I executed the sp_configure followed by RECONFIGURE and it returned me an error. sp_configure ‘optimize for ad hoc workloads’, 1; reconfigure The error message stated the ad hoc updates… Continue Reading Ad hoc update to system catalogs is not supported
- Posted on:
-
Author:
Satheesh
- Categories: SQL Engine
- Tags: Catalog Updates, SQL Administration, T-SQL
- Leave a comment: Ad hoc update to system catalogs is not supported