I come to bother you with a problem I have these three tables
Boarding
vuelo
documento
tipodocumento
luggage
nroequipaje
peso
luggagepacker
nroequipaje
documento
tipodocumento
I'm doing a program in visual basic and I have a transaction that first inserts the shipment, inserts the luggage and when I want to insert the data in the intermediate table it locks everything for 10 seconds and I throw a query expired error, if I execute the insert that in the sql server directly works to perfection taking 0 seconds then it is not an overload of the bd if I execute the insert outside of the transaction it works perfectly so I am completely confused.