Deadlocking occurs when two processes trying to update the same table
at the same time. One is allowed, while the other waits and eventually
gets deadlocked out. This can occure at night during a scheduled
script that updates something, or when someone is doing a lot of work
on the system (like say invoicing, CC processing, etc). Your probably
in contention with the MasterAccounts table.
There are two advanced settings in SQL 6.5 that deal with lock
The first is a percentage and the second is the number of locks. You
want to raise the number of locks you have and then raise the number of
locks required to escalate to a table lock.
Of course, is that all sounce like rubish, you might want to just
to SQL 7.0 to avoid all that. :)
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart