tag:blogger.com,1999:blog-2757538670382901720.post493625966191412517..comments2024-03-21T21:19:29.772-07:00Comments on Dynamics Ax Live: What are the tables InventSumDateTable and InventSumDateTrans used for?Willyhttp://www.blogger.com/profile/15369416963614928863noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2757538670382901720.post-60945787732451474402023-03-29T03:47:58.695-07:002023-03-29T03:47:58.695-07:00You can delete it
We have a job that runs every ni...You can delete it<br />We have a job that runs every night on the SQL Server which does this maintenance<br /><br />DELETE FROM [AXDataBase].[dbo].[INVENTSUMLOGTTS]<br /> WHERE [MODIFIEDDATETIME] < GETUTCDATE() - 45<br /><br />GO<br /><br />ALTER INDEX ALL ON [AXDATABASE].[dbo].[INVENTSUMLOGTTS] REBUILD WITH (ONLINE = ON, MAXDOP = 12);<br /><br />GO<br /><br />DELETE FROM INVENTSUMDATETRANS<brAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2757538670382901720.post-12405737167456356442012-07-12T06:37:39.593-07:002012-07-12T06:37:39.593-07:00Thx for the info Willy, the information from MS ab...Thx for the info Willy, the information from MS about these tables is pretty limited. <br />A customer of ours has 64m records in the InventSumdateTrans table... Are you sure it is safe to delete all these records?Klaas Deforchehttp://www.artofcreation.benoreply@blogger.com