Ladies and Gents,
Due to some wrong functional setup and programming, one of our clients now has a table with 2bln lines which takes upto 2tb of storage. The table data is not being used anywhere anymore.....;)
I have been trying to delete these through processing reports and codeunits, with deleteall. This does not work (ie takes too long and/or sql error).
Online I have seen someone mention following:
Object.SETRANGE(ID,DATABASE::"Customer Price Group"); // This is the table to flush
Would appreciate your opinion or a proposed solution.
Thanks in advance.