SQL Server Error Code – 8696 cannot run query because of improperly f

In this blog post, you’ll learn more about the SQL Server Error Code 8696 and the error message description that is shown

SQL Server Error Code

8696

SQL Server Error Description for the Code :8696

Cannot run query because of improperly formed Spool element with parent RelOp with NodeId %d in XML plan in USE PLAN hint. Verify that each Spool element’s parent RelOp has unique NodeId attribute, and each Spool element has either a single RelOp sub-element, or a PrimaryNodeId attribute, but not both. PrimaryNodeId of Spool must reference NodeId of an existing RelOp with a Spool sub-element. Consider using unmodified XML showplan as USE PLAN hint.