🚀 go-pugleaf

I need help, Please!

We have sqlserver 6.5. 3 or more user programs (COMSERVE machines -
proprietary Code) are inserting records into this one table continuously. New
records are always placed at the end of the table. Another Program goes to
this table, and picks these same records  (doing a select into) and inserts
them into another table, and then goes back to the first table and changes
statuses.

The problem is that when these 3 user programs are trying to insert into the
table, they get various errors: 1. ODBC Time out error. 2. Cannot update this
table..

In the SQL Server's "Current Activity", the Comserver Machine puts Locks in
the table Sometimes there are "Exclusive Locks, sometimes there are table
locks and other times there are Update Locks

We have looked at the Server Configuration Tab of the SQL Server, fiddled
with the settings, called Microsoft, and looked at the design of the tables.
The table is indexed, with Primary key identified, but the problem persists.

Any one has any ideas, I would really appreciate it!

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading