Look into the sql 'truncate table' to empty it initially. David has posted what you need for the ongoing maintenance of the data. While doing the initial delete, you probably want to look at the email error logs form, the email attachments form, and all the other email forms.
Axton On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden <thewallstre...@yahoo.com>wrote: > ** > Hi All, > > I've been wandering around searching for some tips on how to delete 3 > million records sitting in AR System Email Messages form. What I''m doing > right now is just doing it by batch - deleting 10,000 records every now and > then. From the past, I remember doing it directly in the database by > re-creating the Email Messages table (which eventually dropped all the > records). I had no problem with this. > > I just want to know if there are other ways to delete the records without > going directly to the db? > > Thanks, > Gabud > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"