In order to eliminate deadlocks you've to find first what causes them. Check http://support.microsoft.com/kb/832524 and http://www.mssqltips.com/tip.asp?tip=1036, for example.


>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