In this blog post, let’s learn about the error message “10520 – Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and a non-NULL value is specified for the parameter ‘%ls’. This type requires a NULL value for the parameter. Specify NULL for the parameter, or change the type to one that allows a non-NULL value for the parameter.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
10520 – Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and a non-NULL value is specified for the parameter ‘%ls’. This type requires a NULL value for the parameter. Specify NULL for the parameter, or change the type to one that allows a non-NULL value for the parameter.
Reason for the Error
To be update soon…
Solution
To be update soon…