SP4 : 884856 FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Zubeyir SSCrazy Points: 2559 More actions · Answer 1

I think it's something like that

UPDATE C
SET C.Name = 'Blah'
FROM Customers AS C
WHERE C.Name IS NULL

If I'm wrong please correct me.

David Leaver Mr or Mrs. 500 Points: 599 More actions · Answer 2

Mr or Mrs. 500

Points: 599

August 21, 2006 at 6:16 pm

That was my first guess. Can anyone confirm?

Zubeyir SSCrazy Points: 2559 More actions · Answer 3

SSCrazy

Points: 2559

August 22, 2006 at 4:34 am

I can