June 2016 archive

Delete all records in table with C/AL – Truncate

Edited: added a “warnings” section below Did you ever have to empty a certain table entirely in NAV? Well, I admit, you don’t need to do this too often. And definitely not in a repetitive way. Well, I came across a situation where I needed to delete all millions of records from a table every …

Continue reading

Permanent link to this article: http://www.waldo.be/2016/06/30/delete-all-records-in-table-with-cal-truncate/

NAV Upgrade: Import and Compile crashes when NST is running

This is just a small blogpost to mention a few things you need to take into account when you’re working with objects on a large scale – I mean importing, exporting, upgrading, compiling, .. whatever. My scenario I was upgrading a customer from CU3 to CU8. Sure, you might wonder why it took me so …

Continue reading

Permanent link to this article: http://www.waldo.be/2016/06/16/nav-upgrade-import-and-compile-crashes-when-nst-is-running/

Invoke-NAVSQL: Execute SQL queries on NAV databases with PowerShell

Just another CmdLet to bother you with (no really, it’s quite an interesting one – try to keep awake … ;-)). The more you use PowerShell .. and the more you use it for NAV .. you just realize that you have to call out to SQL Server quite regularly. Just a few examples: Backup …

Continue reading

Permanent link to this article: http://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries-on-nav-databases-with-powershell/