The latest weeks I have received  a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You do not have permission to read table XXXXX. … But actually the problem here was not SQL server, it was due to something else. Usually when I get a call with this kind of error I ask some questions to see if it’s not a ‘real’ security issue…

The latest weeks I have received  a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ’$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You [...]

What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest  and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there was only the native database (.fdb) and when you wanted to display information in a form or report coming from multiple companies using standard C/AL then there was the CHANGECOMPANY function and that was about it. Via OCX and Automation you could also use ADO (or something similar) to query…

What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest  and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there [...]

I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com  ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper

I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper  

Recently I had to change the list of available fields in a DropDown  box on a page. As you might already know, a DropDown  is a result of a field having a TableRelation . For example, on a Sales Order page there’s a field “ Sell to Customer No. “. This field has a table-relation towards the Customer table and as a result of that on the page there’s a DropDown button displayed in it’s textbox. This is the case for every TableRelation , but by default only 2 columns are displayed in the DropDown . (the Pk and Description or Name ). To add extra the columns you have to design the table to which…

Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation. For example, on a Sales Order page there’s a field “Sell to Customer No.“. This field has a table-relation towards the Customer table and as a [...]