Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV RTC client user name vs NST user name
ioannidisv
Member Posts: 7
Hi, in order to identify which user blocks or participates in deadlocks I need to know the user involved. But because of NST in between the RTC client and the SQL I only get the user name of the connected NST on the SQL spids.
Any ideas how to get this information from NAV? I suppose it holds it somewhere because based on the Windows user of the user it gets the role and appropriate permissions.
Thanks!
Vassilis
Any ideas how to get this information from NAV? I suppose it holds it somewhere because based on the Windows user of the user it gets the role and appropriate permissions.
Thanks!
Vassilis
0
Answers
For NAV2013-NAV2016 you can only specify the NST causing the locking (SQL)
In NAV2017-NAV2018 you can setup and run Page 9511 "Database Locks" and see the database locks
Nice hint on the 2017-2018 though, I will see how this works on an upcoming installation.
Anyway thanks!