[ cf-dev ] Deadlocks in SQL 2000

[Allan Cliff - CFUG Spain]

I work on a system that sends payments from 1 account to another.   There are thousands of accounts and they can send money to each other or program a direct debit to pay another account when they have no access to internet.   Each set of Transactions is wrapped in its <CFTRANSACTION> tag with the isolation set to SERIALIZABLE.   1 account is very busy and has hundreds of direct debits set up which run at a certain time using cfschedule. This can take up to 6 or 7 minutes to run.   During that time if anyone tries to send money to that account while that account is busy paying out I get an error in the log (Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.)   How can I get around this? Any ideas? I know its Friday.   Thanks -------------------------------------------------------------- Allan Cliff Malaga RedPro S.L. --------------------------------------------------------------