Problem of resources lock with BEGIN..TRAN COMMIT..TRAN

Problem of resources lock with BEGIN..TRAN COMMIT..TRAN

Post by Alextoph » Fri, 24 Mar 2006 21:28:00


FR -*-*-
bonjour,

J'effectue plusieurs enregistrements provenant de plusieurs serveurs
dans une base SQL.
Mon proble est que l'enregistrement rit des donns dans
plusieurs tables et donc quand il y a plusieurs centaines
d'enregistrements la me heure les donns sont mangs dans
les tables.
J'utilise donc un BEGIN..TRAN COMMIT..TRAN pour faire une transaction
comple sans erreur, mais maintenant j'ai des probles de
'resources lock'.

- comment faire une centaine d'enregistrement la me heure sans
manger le donns ?

D'avance merci
christophe

EN -*-*-
hello,
I carry out several recordings coming from several waiters in a base
SQL.
My problem is that the written recording of the data in several tables
and thus when there are several hundreds of recordings per same hour
the data are mixed in the tables.
I thus use a BEGIN..TRAN COMMIT..TRAN to make a complete transaction
without error, but now I have problems of ' resources lock'.

- how to make several hundreds of recording per same hour without
mixing the data?

In advance thank you for your assistance
christophe
 
 
 

Problem of resources lock with BEGIN..TRAN COMMIT..TRAN

Post by Joolz » Fri, 24 Mar 2006 22:15:30

Hi

I've had a similar problem to you, with deadlocks,but if you're
committing the transaction every time there shouldnt be a problem,
would it be possible to see some of the sql code?