MTS Components

hi all,

I developed VB com component doing update,insert,delete to the
databasee(SQL SERVER 2000) I registered this component under MTS
context.

some times every thing is okay and sometimes the transaction stucked
just halt the mts couldn’tcomplete the transaction or abort it just
half
I checked the database and it is locked.when I kill mtx process
everything goes
well and the transaction is aborted with error.

imagine it like I have to do 3 updates to the database
PENDING,INPROCESS,COMPLETE sometimes the procees stuck in INPROCESS
stage
and never come to complete

so any body have any idea what is going on .

thank you in advance