General downloads

NAV SQL Trace Analysis

Author
Peter Tijsma  
Category
General downloads
Date
02/02/2015
Size
2,14 MB
Downloads
1459
MD5 digest
C5D1CDA5C8A0016EE30E93CA0494AA3C
Popularity
Downloaded 1 time in the last two weeks
This tool analyzes a SQL Trace created from a Microsoft Dynamics NAV database using SQL Server Profiler.

It will show how many times each table has been read and written to. I will also show each transaction in detail, including the values used for INSERT and UPDATE statements.

Based on the table License Permission (2000000043), it will also check if the transactions in the trace pass the Limited User write test. When the license contains add-on(s) with special Limited User write permissions, these are taken into account.
Download this file

Screenshots