User ID From which SQL query is Running

(1) Share

Report

Posted on by Heyrohan108

Hello,

One of client is facing lots of table locking issue in Navision 2016 IN and we are not able to Identify due to which user it is causing. Is there any way to get from which user ID the sql query is running so that we can identify the User due to which table locking is occurring.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, you can try check Table 2000000110 Active Session.

And then try the solutions below.

https://www.olofsimren.com/kill-sessions-in-dynamics-nav/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No