Odd error in writing to a table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Odd error in writing to a table

Hi– We are experiencing a situation where ‘partial’ records are being written to our database. Someone who understands the internals of SQL Server 2000, please correct me, but its my understanding that updating a field is really a delete of the record followed by an insert of the record with appropriately updated fields as far as the internals of the database go. We have a sql procedure that updates two fields in a batch of serialized records (1,000 to 5,000 records at a time). By necessity, this is occuring within a cursor that is also executing sprocs on other linked servers within the same loop. On occation, usually when the system is stressed, one field will write and the other will not for the same record in the main table. Has anyone else run into this with SQL Server 2000. We’re running our system on a quad processor server with 8 gig of ram. Thanks in Advance –Jim
if it don’t write in Linked Server’s Database you need to re-ensure availability of those Linked Servers .
and yes while you update a field its deleted and then a new values are inserted , refer *deleted tables* in BOL for more. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami