Constraints/Bug in using VB6 and SQL Server Transaction

[nurdinsena]

I had the same problem when storing multiple programs with state computer "Transaction Number" together, which is where the Index database that is used is "Transaction Number".

So, in the successful storage of just 1, and the other with "Error Trapping" will repeat the incrase Transaction Number. And in the storage procedure I use TTS (Time Tracking System) with BeginTransaction, CommitTransaction and RollBackTransaction. But there are some times of events, some of the data in storage, eg "Data Details of other computers enter into a transaction that is stored, so also there are some updates stock".

In your opinion as an expert what I need to improve? Thank you

 

[gmmastros]

Are you using SET XACT_ABORT ON in your code?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[nurdinsena]

I'm not using SET XACT_ABORT ON...

 

[gmmastros]

You should.

http://technet.microsoft.com/en-us/library/ms188792(v=sql.90).aspx

When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.

When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing. Depending upon the severity of the error, the entire transaction may be rolled back even when SET XACT_ABORT is OFF. OFF is the default setting.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom