Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

EXCEPTION_ACCESS_VIOLATION 0000000000000008 When attempting to reference the "deleted" table from an OUTPUT statement during MERGE

Attempting to MERGE a table using a table variable (using a Table Type) causes the above exception to be raised and the session is immediately terminated. Reproduced the error on multiple servers:

Server 1:

OS: Windows Server 2012 R2
VMWare 5.5
8GB RAM
2x2.2GHZ CPU

Server 2:

OS: Windows Server 2012 R2
128GB RAM
12x2.2GHZ CPU

Dedicated box, nothing running other than the attached query. I have also tried the query on SQL Server 2014 (12.0.4213.0) and the same issue occurs.

0 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base