<!--

    , \¯¯¯¯¯¯¯¯¯¯¯/,          _  _
   ,   \_________// `        | || |   |¯|           |¯|                |¯|
  ,   //\```````\\   `       | || |   , ,           , ,  _   _|¯|_     | |
 ,   ////\```````\\   `      | || |    \ \         / / /  `,|_   _|___ | |
,___//////\```````\\___`  /¯¯  ||  ¯¯¯\ , ,  /¯\  , ,   ¯¯\ ` | | / __|| |___
`¯¯¯\////,//////////¯¯¯, | /¯¯||| |¯¯\ | \ \/   \/ /  ,___| | | || /   | ,¯¯\ `
 `   \//,//////////   ,  | \__||| |__/ |  ,   ,\  ,  /  __  | | || \ _ | |  | |
  `   \,//////////   ,    \__,.||.¸___/    \_/  _/   \______¸`\__\\___||_|  |_|
   `  //¯¯¯¯¯¯¯¯\\  ,
    `//¸_¸_¸_¸_¸_\\,


    The database management tool that meets every database administrators needs.
    Create and alter data correctly, over multiple servers and instances.
    Don't work for your server, let the server work for you.

    Includes;
        Monitoring, Management, Reporting, Tuning, Dashboards, Security

    Supports;
        Oracle, MS SQL Server, MySQL, Sybase, PostgreSQL, MariaDB, MongoDB

-->

<meta name="description" content="Solutions for SQLserver error code 8697: Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d." />
<meta name="keywords" content="MS SQLServer, Microsoft SQL Server, Database Errors, High Availability, Solutions, Troubleshooting Sqlserver errors 8697 Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d."/>
<title>8697 - dbWatch solutions library</title>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="stylesheet" href="/css/solution2.css">
	<link rel="icon" type="image/png" href="/images/favicon-32x32.png" sizes="32x32">
</head>
<body>
    <header class="header">
        <div class="navbar">
            <a href="https://www.dbwatch.com/" class="navbar-brand">
                <img src="/images/WebsiteLogo.png" alt="dbWatch Logo" id="logo">
            </a>
            <nav>
                <a href="https://www.dbwatch.com/">Visit dbWatch.com</a>
                <a href="https://www.dbwatch.com/support/">Support</a>
                <a href="https://wiki.dbwatch.com/">Wiki</a>
                <a href="https://www.youtube.com/channel/UCKr0Qz4Kzp2oPVPQei_2Sjg">YouTube</a>
            </nav>
        </div>
    </header>
            <div class="container">
             <section class="meta">
    <h1>Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d.</h1>
    <p><strong>Solution ID:</strong>8697</p>
    <p><strong>Type:</strong> <a href="/Sqlserver/">SQLServer</a></p>
</section>
<article class="solution-detail">
    <h2>Error</h2>
    <p>8697</p>
</article>
        <article class="solution-detail">
            <h2>Severity</h2>
            <p>16</p>
        </article>
        <article class="solution-detail">
            <h2>Event logged</h2>
            <p>No</p>
        </article>
        <article class="solution-detail">
            <h2>Description</h2>
            <p>Cannot run query because in XML plan provided to USE PLAN, element %ls must have %d %ls nodes as children, but has %d.</p>
        </article>
        <div class="more">
            <p>Browse all solutions to database errors from <a href="/Oracle/">Oracle</a>, <a href="/Sqlserver/">MS SQL</a>, or <a href="/Mysql/">MySQL</a></p>
        </div>
    </div>
  <footer>
            <p>© 2024 dbWatch AS. All rights reserved.</p>
  </footer>

<script async src="https://www.googletagmanager.com/gtag/js?id=G-BWBNDRJF1B"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());
  gtag('config', 'G-BWBNDRJF1B');
</script>
</body>
</html>
