Transaction limitations

  • Thread starter Thread starter nashak
  • Start date Start date
N

nashak

I am updating a table of a few million records with a update file i.e
based on the data in the update file, I am updating my records.

My code throws an error everytime it reaches a particular record. The
record is fine, logic is fine. If I use the same code with a file that
has data for only that record to be updated, it works fine.

I wonder if there is a limit to the number of SQL statements that can
be contained in one transaction or number of operations that a
transaction can hold.

Thanks,
 
1.) Which database are you using?
2.) What's the structure of the affected table(s)?
3.) What's the error message you receive?
 
Hello,

DB - SQL Server 2000

An update, the error thrown is not at a particular record. It can
happen anytime. Error messages are not consistent. I think it has to do
something with number of steps in a transaction etc.
 
Back
Top