Objects4NAV

SQL

NAV Instance and Tenant Administration

This package contains the basic functionality to manage your Dynamics NAV installations.  The C/AL code is written for Dynamics NAV 2015 and it can manage installations from Dynamics NAV 2013 R2 and later. Included also is a PowerShell script package.  The package uses extended version of PowerShell for NAV that is available for download here.  This is intended to be the building block to start your own management tool both in your cloud environment and…

NAV SQL Trace Analysis

Download 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…