>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

Yh,

See if this discussion may be useful

http://forum.lessthandot.com/viewtopic.php?f=17&t=6518