How to: Get record count for all tables

In newer Nav versions the tables overview in development environment/database information has gone. So how to get that list back ? Let’s got to SSMS (Sql Server Management Studio). There select the database, for which you want that information. Right click on database -> Reports -> Standard Reports -> Disk usage by Top Tables There we… Continue reading How to: Get record count for all tables

Check License state of Objects

In Nav forums it’s quite often asked, how to check, if a object is within the current loaded license. There are some solutions for Nav 2009. I did not find a satisfying solution for newer Nav versions. So i’ve developed a “License Permission” Page, which lists Objects and their Permissions. Object IDs, which are not in the… Continue reading Check License state of Objects

Where-Used-Tools for Dynamics Nav

Dynamics Nav does not ship with a Where-Used-Tool, although it is often needed. A Where-Used Tool is a tool, with which you can check, which nav objects use/reference a certain nav object or a certain table field. Idyn has developed a widly used Toolset, the Object Manager Advanced (OMA). It is very helpful, contains that kind of tool,… Continue reading Where-Used-Tools for Dynamics Nav