Table Locking became major issue!!!!

southindian
southindian Member Posts: 247
edited 2011-06-29 in SQL Performance
Dear all,

Am getting a Table lock error.

Following are the options that i have tried to resolve table locking but i have failed

1. Set the transaction type to "Update Locks" in Property
2. Removed unwanted code and tuned it well.
3. Checked Option like Updating Statistics , indexing the Objects in MS-SQLand it is updated
till date.

But Still we are getting Table lock problem in almost every form , report dataport., especially Sales Line table.

(Kind Note : Recently Our Client has migrated from Version 4.0 to 2009. I felt that due to this This Problem is arising. Kindly Suggest me Best option to resolve this.)
Microsoft Dynamics NAV Classic
The Sales Line table cannot be changed because it is locked by another user.

Wait until the user is finished and then try again.
OK


Kindly Suggest me Best option to resolve this.

With regards,
Vijay

Comments

Categories