anywhere to check who is the user who lock the table while user unable to do posting

Hi all,

I need to know is it possible to trace who is the user who lock the table from NAVISION?

It can be checked in 2 ways I guess.

  1. try to use activity monitor in sql server
  2. have a look around event viewer

Hi
you can go in sql server database,select particular database , in this db select user table and fire select query on this user table. Select * from user table.