Another Table lock question

idiot

Let's make reference to SQL server, Sales Line Table & 2 companies.
Both companies exist in the same database.
In SQL Enterprise Manager, there are 2 Sales Lines Tables:
[CompanyA$Sales Line]
[CompanyB$Sales Line]

If a user in Company A & another user in Company B post Sales Orders simultaneously, will the Table lock be activated?
How does Navision handle this situation?

kriki

[Topic moved from Navision forum to SQL General forum]

kriki

Navision does a TABLELOCK on the table. In Navision this would lock the complete table (once the command arrives at the servering. It is buffered on the client until the buffer is full or until a response from the server is expected). On SQL, it does NOT lock the complete table. It WILL lock all records that are read after this command and maybe SQL will decide to lock the complete table. So this means the 2 sessions will not lock each other. Of course ONLY if they DON'T lock records in a table with DataPerCompany=No.