How can I check a Table status lock

icobaniicobani Member Posts: 70
My problem is in posting routin. I have a error for lock. How can I check ?
Ibrahim COBANI | Dynamics-NAV Developer Team Manager
I m a Consult

E-Mail: ibrahim@imaconsult.com
My BLOG

Comments

  • kinekine Member Posts: 12,562
    If I understand correctly, you got error about "table locked by another user" when posting some document and you want to know how to prevent that...

    If yes, there is no way how to detect locks. But there is way how to eliminate long locks - optimalization and correct code design (not using Confirm during transactions etc.)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • WaldoWaldo Member Posts: 3,412
    Are you using SQL or Native.

    For SQL I know this:
    You can use the session monitor to view locks/blocks.
    Personally, I use the SQLPerform tools to investigate locks and blocks.

    I don't think this is possible with the native session monitor.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.