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 …
Permanent link to this article: https://www.waldo.be/2017/04/11/stored-procedures-on-a-nav-database/
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 …
Permanent link to this article: https://www.waldo.be/2016/06/30/delete-all-records-in-table-with-cal-truncate/
… 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 …
Permanent link to this article: https://www.waldo.be/2015/04/03/microsoft-sql-server-2014-runtime/
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 …
Permanent link to this article: https://www.waldo.be/2015/01/21/nav2015-modifyall-behaviour-on-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 …
Permanent link to this article: https://www.waldo.be/2012/08/01/deny-object-changes-in-sql-server/
Loading ...