Recordlevellocking in SQL

xavigepe

Sorry but I'm absolutely newbie in this topic. If I am using Navision 4 SP3 with SQL Server. Is it normal that I have errors showing "Table serial no. is locked by other user..." . Is this normal having a table lock when I'm using SQL?.


Thanks,

kine

It is normal, because the message is not precise. It means that "record you want to read (modify) is locked (by rowlock, page lock, table lock...)".

kriki

[Topic moved from Navision forum to SQL General forum]

xavigepe

Sorry but I still think there's some problem with what I am doing. I have lots of lock messages and even when I'm trying to delete a sales header created by me I get a message saying "Sales line is blocked by other user". Do you think this is really normal using SQL Server?.

Marije_Brummel

No, it is not normal but somtimes reality for users.

Can you identify the processes that are blocking each other? You can see it in the database, info, users screen.