I have few tables in Navision 5.01 where i am facing the data consistency error. I am preparing the DB for a fresh installation where i am required to delete all the existing transactions. Few of the tables like Value Entry, Purchase Line, Dimension Tables are showing this error while doing the data deletion. Also after the message, database becomes suspect. While trying to optimise the table, the same data consistency message appears.
Is there any other way to delete the data. Can the data be deleted from SQL Query without facing any issues in the future?
Your comment on the above will be highly apppreciated.