Is it true that although SQL utilizes record-level locking, that the Navision code continues to utilize table locking and where can I get more information on how SQL locks navision tables?
SQL Server uses row-level locking as the finest grained locking available (to the user), and Navision also uses row-level locking. Navision never hints a page or table level lock, and in fact mostly hints a row level lock, preventing SQL Server from otherwise using a page or table level on its own initiative. You can check this by running a profile on some Navision activity - you’ll see the ROWLOCK hint many times. There is information about locking in the Application Designers Guide and the Troubleshooting guide. You can also direct specific questions to this forum of course.