In this blog post, let’s learn about the error message “8697 – Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
8697 – Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d.
Reason for the Error
To be update soon…
Solution
To be update soon…