We’re combining the NAV Sustained Engineering Blog with the NAV Team Blog , and will no longer be posting on the SE blog. You can follow our future posts on the NAV Team Blog . Also, the posts from the... (Continue reading)

When doing a technical upgrade running Microsoft Dynamics NAV CSIDE client on the same machine as your SQL server, please run the CSIDE client with either UAC turned off or with full administrator rights... (Continue reading)

Recently I was asked about the encoding that it is done for record links in SQL.
If you are not familiar with Record Links, which have been available since NAV version 5.0, just open any Card or List... (Continue reading)

It should be a common installation scenario to have NAV 2009 components installed on three different machines, one for the database hosted by SQL Server, one for the Microsoft Dynamics NAV Server (middle... (Continue reading)

We are glad to announce that compatibility between Business Notification and SQL Server 2008 is as of now verified and confirmed. Business Notification can run on SQL Server 2008 provided that the 2 following... (Continue reading)

Cursor Types

One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of Fast-Forward cursor types to Dynamic cursors. The same change was implemented in version 4 from build 26410, which is Version 4, SP3 Update6(940718) + KB950920.
The change of cursor type can also mean a change in behaviour. With Dynamic cursors, SQL Server more often optimises for the ORDER BY - part of a SQL query than is the case with Fast Forward cursors. This is because a result set based on... Read the full text.