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.

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

User ID From which SQL query is Running

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