Share
ReportIs there a way to tell which user has a specific table locked down when they are posting something?
*This post is locked for comments
You’re offline. This is a read only version of the page.
100
Is there a way to tell which user has a specific table locked down when they are posting something?
*This post is locked for comments
Thanks for all your suggestions!
You can find from Navision also
Go to
File-->Database-->Information
Gos to Sessions tab
Click Drop down on current sessions
Set filter on Blocked yes.
this will give you only which user has blocked other users..
Hi
Several ways,
Inside of SQL server you could:
Go into the management tools and spam refresh to watch what the users connection does (You may miss it though)
Use tracing to watch the actual SQL calls taking place inside of SQL Server (SQL Skills required to setup and run)
Use the client monitor inside of NAV together with the development parts and get a trace of the entire process (Including locks)
The last option would be the recommended (There are also extra NAV components that can be loaded to give greater detail from the Client Monitor, but these require a developer licence to run)
Hope this helps?
You can get this by dynamic nav and sql
by dynamic nav file - database-information -session -current session then delete user's who blocked
from sql
sp_who2 stored procedure
you can also run debugger when error blocked display then trace code you will know the table that make block
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (