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...
Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,...
Upgrading Dynamics NAV (database upgrade) is a timely task, but the time to upgrade (transfer data) can be somewhat reduced on sql option by taking few simple steps. Due to large transaction volume and amount of indexes and sifts, transfering data (running upgrade toolkit codeunits: step 1 and 2 ) can...
This will only apply if the following is true: 1. You're upgrading from 3.x or 4.x to 5.0 2. You're using average cost 3. You have the Avg. Cost Calc type to Item&Variant&Locatoin IF you are using Average Cost and IF your Average Cost Calc. Type is Item & Location & Variant, when...