Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
What you need to do is to stop DEADLOCKS.
Speak to your DBA's about how you can optimise your operations to limit the possibility of deadlocks happening.
If you are mostly doing reads then it is not all that hard to change the queries to read without locking rows or pages etc.
For insert/update it is a little more difficult however this is all pretty standard stuff. _________________ WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum