This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0). However, the table objects in 4.0 versions did not have the Clustered property set on...
While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts. In 2006 I started to put all this into a structured...
The link below lists build numbers, KB numbers and links to cumulative updates updates 1 to 9 for SQL Server 2005: List of build numbers and cumulative updates 1-9 for SQL Server 2005 Also see this post for relevance of SQL Updates to Microsoft Dynamics NAV: Overview of updates for SQL Server 2005 SP2...
I am sure I am not the only person that has had to argue with a client as to how hardware needs to be configured in a Dynamics NAV environment. Typically bigger companies with larger internal IT support generally have their way of doing things, and its often very hard to sway them to do things "The...