December 29, 2005 at 1:52 pm
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?
December 29, 2005 at 1:56 pm
A search on support.microsoft.com turns up quite a few hits for 8264 internal sql server error as the search query. Several look like they might apply to your situation.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply