Emmitt: Thanks for the explanation. They do run with STATICDB OFF. So I'll tell him to change QUALCOLS to 10 and see if that's the offending statement!
Karen > QUALCOLS comes into play during multi-user UPDATEs. IF it is set to 2 AND > FASTLOCK is ON AND STATICDB is ON you can see a performance improvement since > R:BASE will use row locking instead of page locking. Practically speaking, > this only has an impact if multiple users are attempting to update rows > within the same page of data. If STATICDB and FASTLOCK are not ON, then > QUALCOLS > may as well be 10. STATICDB, FASTLOCK and QUALCOLS must all be set ON for > all users. > >
