Is there a smart way to do updates in small chucks at a time just specifying what amount of records I want to update? Or do I have to use...

Got error running this:

ALTER INDEX I_ObjectID ON tblObjectUpdateInfo DISABLE

ALTER INDEX PK_tblObjectUpdateInfo ON tblObjectUpdateInfo DISABLE

UPDATE tblObjectUpdateInfo SET ObjectID = ObjectID + 99999;

Msg 8655, Level 16, State 1, Line 3

The query processor...

I'm running Simple logging.

I have this Index too... and one more questions about that. Is this necessery when I have the clustered [ObjectID+PocketPCID] index? Will a search without the extra...