Hi Siva: You can write a SQL command within Query Analyzer like this. Delete eventTable where condition ..... I believe it will be faster, but make sure you check the delete action within Axapta before you delete these records in case there's other tables that you need to delete as well. Good luck. Jeffery
--- In development-axapta@yahoogroups.com, Siva kumar <[EMAIL PROTECTED]> wrote: > > Hi, > > I am having sround 9 lacs alerts in the eventInBox table. I tried to delete it, It took 4 hrs to delete 10000 records. To complete 9 lacs It will take an week. Is there any easy way to delete quickly. > > Even I tried to delete the alert in manahe alert tule form. Same thing happening. > > Thanks, > Siva > > > We Born to Win... > > > > --------------------------------- > Be a better Heartthrob. Get better relationship answers from someone who knows. > Yahoo! Answers - Check it out. > > [Non-text portions of this message have been removed] >