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.)
Comments
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.)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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