Posted inDynamics NAV & BC Tips & tricks

Error: table 2000000009 has no name

If you get following error: Table 2000000009 has no name then the database is corrupted. In detail it means sql view “Session” is missing in the database! This can be a result of a crashed backup/restore process or a failed conversion process. Bron : Moxie4nav Lees…
Posted inDynamics NAV & BC Tips & tricks

Active directory queries from C/AL

I wanted to get a list of all NAV users with displayname and roles per user in a report. The data base is table “Windows Access Control”. One field should show the displayname of each user. The displayname can be read from hidden table “Windows Object”,…
Posted inDynamics NAV & BC General

C/AL Coding Guidelines

The new C/AL Coding Guidelines are updated and published by Microsoft. Link : C/AL Coding Guidelines As far as I know there is no official PDF document with the guidelines yet, so you can download the unofficial one here: [download id="131"] [download id="132"]