Been having a bout of dead locks in SQL server on a large network.
Our application uses ODBC SQL Passthrough to connect to SQL Server.
The application uses client side processing to handle updates in one atomic transaction in the following manner:-
1) Update sales invoice (1 header and 2 child) via SQL inserts
2) Generates a delivery order based on the sales invoice (1 header and 1 child) via SQL inserts
2) Update customer balances file via SQL inserts
3) Update inventory via SQL inserts
4) Update general ledger via SQL Insert
Surrogate keys are used for sales invoice and delivery orders documents.
We're having lots of dead locks lately and would like some guidance on tracing the source codes that are causing the deadlocks and fix it.
Thanks in advance.
Yau