I need help....What do you think ??? Anybody help me please ...thank a lot
!!!

You have designed two transactions as follows:


T1 T2
Begin transaction Begin transaction
Update Customer Update CustomerHistory
? ? ? ?
Update CustomerHistory Update Customer
? ? ? ?
Commit Transaction Commit Transaction

Above two transactions occasionally gives you error as transaction #4 has
become victim of deadlock.
You want to execute both the transaction though either of them is a victim
of deadlock

What will you do?

A. In second transaction put update customer statement before updating
customerhistory
B. Set deadlock priority low
C. In both the transacation check error , If its = 1205 then execute the
transaction again.
D. Set lock_timeout = 0