I am getting this error:
---------------------------------------------------
Server: Msg 8624, Level 16, State 1, Line 67
Internal SQL Server error.
----------------------------------------------------
The update ststements looks like:
----------------------------------------------------
UPDATE tableA
SET tableA.Column1 =
CASE
WHEN tableB.Column1 IS NULL AND @ForceUpdate = 0
THEN tableA.Column1
ELSE ltrim(rtrim(tableB.Column1))
END,
<snip>
.. For 20 columns
<snip>
FROM tableA
INNER JOIN TableB
ON <JOIN CRITERIA>
INNER JOIN tableC
ON <join criteria>
WHERE .....
--------------------------------------------------------------------
The line 67 is the line where the UPDATE keyword is. I have seen this problem on and off for the past several months. It only seems to affect the databases in 1 of several servers. Today it is only affecting 1 database out of 50 on that server. In the past I have solved this problem by removing semi-reduntant indexes. Unfortunatly, I am running out of indexes, and all the indexes and tables ar ethe same accross all the databases.
Any ideas?