Tag: 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: https://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: https://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: https://www.waldo.be/2015/04/03/microsoft-sql-server-2014-runtime/

NAV2015: MODIFYALL behaviour on SQL Server

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: https://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: https://www.waldo.be/2012/08/01/deny-object-changes-in-sql-server/