In this blog post, let’s learn about the error message “41820 – A MARS batch failed due to a validation failure for a foreign key constraint on memory optimized table ‘%.*ls’. Another interleaved MARS batch inserted a row that references the row that was deleted by the failed batch.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
41820 – A MARS batch failed due to a validation failure for a foreign key constraint on memory optimized table ‘%.*ls’. Another interleaved MARS batch inserted a row that references the row that was deleted by the failed batch.
Reason for the Error
To be update soon…
Solution
To be update soon…