SQL Native Client Version

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...
Continue reading »

Job Queue stops when lock time out occurs

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 will not be able to...
Continue reading »

Batch Job to Quit if it is blocking

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. [code htmlscript=”false”]FOR i := 1 TO...
Continue reading »

Blocking Log

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 each session to be able...
Continue reading »