Re: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000

2004-04-02 Thread Allan Cliff - CFUG Spain
: '[EMAIL PROTECTED]' Sent: Friday, April 02, 2004 10:47 AM Subject: RE: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000 Are the transactions inserting new rows or are they also updating anddeleting?Try using "Read committed" -  this may help but it could ca

RE: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000

2004-04-02 Thread Robertson-Ravo, Neil (RX)
CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 09:41 To: [EMAIL PROTECTED] Subject: Re: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000 They are currently all CFQUERY. - Origin

Re: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000

2004-04-02 Thread Allan Cliff - CFUG Spain
They are currently all CFQUERY.     - Original Message - From: Robertson-Ravo, Neil (RX) To: '[EMAIL PROTECTED]' Sent: Friday, April 02, 2004 10:37 AM Subject: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000 Hmmm, well DEADLOCKS are usually a

RE: [ cf-dev ] Deadlocks in SQL 2000

2004-04-02 Thread Robertson-Ravo, Neil (RX)
April 2004 09:28To: CF - ListSubject: [ cf-dev ] Deadlocks in SQL 2000 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 ha

[ cf-dev ] Deadlocks in SQL 2000

2004-04-02 Thread 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 tag with the isolatio