you can empty this table.
For all companies run this
inventSumLogTTS::deleteCommittedItemId('');
regards
harry
________________________________
From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Steeve Gilbert
Sent: Fri 4/21/2006 7:21 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE : [Axapta-Knowledge-Village] Database size
Hi Harry,
No, we don't use Master Planning... yet. The story is that we came close to using it but then we end up building our own, smaller, in-house production planner. So we've never run it. But we will probably use it sometimes later on to plan part of our production.
In the mean time, can we empty this table?
Steeve...
-----Message d'origine-----
De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Harry Deshpande
Envoyé : 21 avril 2006 13:54
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : RE: [Axapta-Knowledge-Village] Database size
hi
Master planning regeneration deletes records from this table. Do u run this function?
regards
harry
________________________________
From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Steeve Gilbert
Sent: Fri 4/21/2006 4:26 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Database size
Hi group,
We just happen to look at the size of the tables in our live
environment. We were wondering why our DB is 35 Gb and it's only been
2.5 years since the go-live. It ends up that 35% of the size is
occupied by table INVENTSUMLOGTTS. Is it possible to purge that table
since it's only a log?
Hope you can help me on this.
Have a nice day!
Steeve...
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.