Hi Siva,
  
  Try Deleting Data in table using following option
  Administration -> Periodic -> SQL Administration -> Table action -> Truncate
  In SQL Administration form select the table whose data you need to delete, and then use this option. This option is much more faster then any other option you apply. I suspect you may be using while loop to delete the data in the table. This Truncate option uses the MSSQL Truncate command internally to delete all records form any table.
  On the other hand deleting this much of recods will always takes time.
  
  To implement Alert functionality, Dynamics AX uses following tables
  EventParameters
  EventCompanyRule
  EventCUD
  
  EventInbox
  |
  |- EventInboxData
  |- EventRule
     |
     |-EventRuleData
     |-EventRuleField
     |-EventRuleIgnore
     |-EventRuleIgnoreAggregation
     |-EventRuleRel
        |
        |-EventRuleRelData
    
  Tables are related as explained above. If you need to delete data from all the tables related to Alert then start deleting data in table from bottom to up.
  
  Hope you understand what I wnated to explain.
  
Hey, you u right....
  
  We Born to Win....
  
  Regards
  
  Nitesh
  
Siva kumar <mgsivani@yaho...> 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]



        

      
---------------------------------
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.

[Non-text portions of this message have been removed]