Recently faced a problem of table locking which goes in not responding stage and finally user close the tab ,but when user opens the session again it actually messed up the critical data (It seems unimaginable force was roaming that time when this happens). Eventually after trying couple of days for data correction I need to contact Microsoft to restore the database.
Tag Archives: Session
Cross Session Events and SELECTLATESTVERSION
Recently I worked on something very interesting related to a integration between MS Dynamics Nav and an external payment service provider. I had to use custom Cross Session Events to solve a problem which I think it’s worth sharing. So this why this post.
Get Session Information for all NST’s – PowerShell Version
The function is called “Get-NAVServerSessions”, so with an extra s at the end. It read all properties from the active session table, and also adds the tenant id for each database.
Get Session Count over multiple NST’s
Sometimes you need to see for different instances how many sessions are connected.
You could achieve this with piping multiple PowerShell statements into each other, but not always.
Design Pattern: Cross-Session Events
In Microsoft Dynamics NAV you can fire a function whenever something changes within your session (and from NAV 2016 this is even easier with the new Event model), however there is not an easy way to know what is happening in other sessions. Sometimes you would like to know what has happened since your last read, without reading everything again, e.g. when you need to pass a large dataset to a Control Add-in.
Get all the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine
Have seen many of the forum users are posting question on how to find active user sessions in an instance of Microsoft SQL Database Engine.
In order to get the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine, we can use the “sp_who2” SQL stored procedure.
Local Dad Amazes Users with Active Session Table!
Today I had an issue with a customer. They’d run out of user licenses, and it was a mystery as to why. They actually had more concurrent user licenses than they needed, so that wasn’t it. We looked into the Active Session table to see what might be going on.