Another possibility. There is a bug in SP4.

Execute below statement:

ALTER TABLE “table” DISABLE TRIGGER ALL

and run updates(Trigger based).

If you are able to run update without “Internal SQL Server Error”;...