We use Nav3.6 since 2003 and use it for the administration of 7 companies. From 2003 to 2009 the size of the SQL Server 2000 database grew from 0 GB to 55GB. Since 2009 it grew to 160 GB.
It seems that the number of tables with unclear names [Company Europe$75832$1] has grown significant the last few years. There are now approximately 200 of these tables per company, so times 7. Apart from the normal tables such as [x$G_L Entry].
What is the purpose of these tables and how can I can know which of these tables are necessary and which are not?