Forum Discussion

auz405's avatar
auz405
Copper Contributor
Nov 04, 2024

Has the SQL Server Bulk Insert Assertion Error (KB 2700641) Been Resolved in SQL Server 2019?

Hello SQL Community,

I’m reaching out to confirm whether the specific issue described in KB 2700641 has been resolved in SQL Server 2019. The issue in question, which occurred in SQL Server 2008 and 2008 R2, involved an assertion error during BULK INSERT or BCP operations without the CHECK_CONSTRAINTS option enabled. Although our tables do not have constraints to check during insert operations, we had to use the CHECK_CONSTRAINTS option as a workaround in SQL Server 2008.

I have reviewed the release notes for SQL Server 2012 - 2019 but couldn’t find an explicit mention of this particular fix. Before we remove the workaround from our code, could anyone confirm if this issue has indeed been addressed in SQL Server 2019? Or is there any documentation available that confirms this bug was fixed in a specific SQL Server version?

Thank you for any insights or official references you could provide!

No RepliesBe the first to reply

Resources