I received another email describing error received due to my executing script from my previous article .
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option ‘optimize for ad hoc workloads’ does not exist, or it may be an advanced option.
Let us quickly see the reproduction of this error in following image.
The reason this error is happening because of not enabling advance option. Run complete following script and it should fix the problem.
sp_CONFIGURE 'show advanced options',1
sp_CONFIGURE ‘optimize for ad hoc workloads’,1
Reference : Pinal Dave (https://blog.sqlauthority.com)