I try to execute a update query in SQL Server 2016 (v13.0.5026.0) and get these error messages:
UPDATE tableName SET fieldName1 ='a long query with some html tags and all it has 3600 chars' WHERE fieldName2 = 12345
And get this error,
Msg 596, Level 21, State 1, Line 0
Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
As Microsoft website suggested, I tried an update to Cummulative Update(CU6) and changed to 13.0.5292.0 It says CU1 update has to fix it but doesn't solve the issue.
This query creates a dump file, and the log has the following message:
SqlDumpExceptionHandler: Process ID generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
The same update query works on other table in the same database.
Any help would be great.
