** Best to set up an escalation that fires periodically. Decide if you want to keep any for historic searches. We keep a month or so. Once you decide then set up the escalation to remove batches of them. Set the run if to do small groups so you don't impact the server. After you get caught up have the escalation run based on some thing like Create Date <= $TIMESTAMP$ - (30 * 24 * 60 * 60) which will delete anything created greater than 30 days ago. Dave ------------------------- dave.shell...@tycoelectronics.com (Wireless)
________________________________ From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Tue Dec 08 18:56:56 2009 Subject: safest and fastest way to delete AR Email records 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"_