Tag Archive: SQL Server

Stored Procedures on a NAV database?

Recently, I came across a customer, where a partner had implemented some Stored Procedures on a Microsoft Dynamics NAV 2017 database. Now, for any change on SQL level that comes to my ears, my first reaction is always “Nooooooooo“. Or as a pictures tells more than a thousand words: First thing I did was googling …

Continue reading »

Permanent link to this article: http://www.waldo.be/2017/04/11/stored-procedures-on-a-nav-database/

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/

Microsoft SQL Server 2014 Runtime

… is here! In fact, it’s available since April 1st .. but I had other things to blog about ;-). The Microsoft SQL Server Runtime edition is an interesting way for partners to offer a decent SQL Server edition for their Microsoft Dynamics NAV customers. It’s in fact a standard edition of SQL Server, but …

Continue reading »

Permanent link to this article: http://www.waldo.be/2015/04/03/microsoft-sql-server-2014-runtime/

NAV2015: MODIFYALL behaviour on SQL Server

012015_2309_MODIFYALLbe1.png

I’ve just spent an evening on something that I noticed earlier in one of my projects that wasn’t clear to me. And when you don’t understand something? You write blogposts, right? You might have figured from the title .. It was regarding the MODIFYALL. Now, long time ago – in 2008 – I wrote a …

Continue reading »

Permanent link to this article: http://www.waldo.be/2015/01/21/nav2015-modifyall-behaviour-on-sql-server/

Deny object changes in SQL Server

Internally at iFacto, we have been working quite heavily on our infrastructure. And if I say "heavily" .. I mean unbefreakinglievable heavily. In a way: we threw everything out .. and we placed a lot in. But we only did this after going very deep in pre-defining about everything we could predefine: user security, SQL …

Continue reading »

Permanent link to this article: http://www.waldo.be/2012/08/01/deny-object-changes-in-sql-server/

NAV Change Listener is not always listening..

Since NAV 2009 RTC, live has become .. let’s say .. more challenging regarding “installations”, isn’t it ;-). There are loads of settings, parameters and configurations you have to get familiar with (Delegation, SPN, SQL Server, Active Directory, Kerberos fluff, …) before you’re even able to get it running. And then .. when you’re completely …

Continue reading »

Permanent link to this article: http://www.waldo.be/2012/05/14/nav-change-listener-is-not-always-listening/