-
I wrote a solution to log blocking in NAV with the help of Microsoft SQL Native Client. I wanted to be able to use this solution for a client but then ran into a problem with the SQL Native Client. There are three versions out there and the connection string must include the version installed [...]
-
Running NAS with Job Queue will start a timer to process Job Queue Entries every two seconds. In the original code the Timer is disabled before checking the Job Queue Entries and then enabled again after the process. If NAS … Continue reading →
-
I have a batch job that is running regularly to adjust items. Since this is running during working hours I want to stop the batch if it is blocking another user. This is the loop that my batch does. FOR … Continue reading →
-
Today I needed to see who was blocking another user and why. I created a few objects to monitor the Session table and log the information. I use ADO to connect to the database server to get the current SQL statement for … Continue reading →