Regarding your comments
I had to do the same with the sales edit lines form. When selecting
sales order lines to populate for Invoice, picking list etc, it
selects the lines for update. This is unnessessary. I changed the
query object salesChooseLines and removed the code where it selected
it
I have had same problems. In Administration - Inquiries - Database -
locking database users. This helps identify the SPID of the user
that's causing the locking. If you go to Query Analyser - type in
sp_who "bmssa" or sp_who. This gives you the user list and you can
figure out which user (spids
--- In [EMAIL PROTECTED], "subhamit59"
<[EMAIL PROTECTED]> wrote:
> Anyone knows how to get rid off exclusive table locking in SQL
> because our users cannot work due to X TAB locks.
> The system is heavily loaded with transactions on SQL2000 SP3a.
> The memory usage on SQL seems to stay at aro
3 matches
Mail list logo