Re: [Axapta-Knowledge-Village] Delete alerts
Hi Nitesh, thank you. Finally I deleted from SQL. Nitesh Ranjan <[EMAIL PROTECTED]> wrote: 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 <[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 1 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] We Born to Win... - Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Delete alerts
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 <[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 1 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]
[Axapta-Knowledge-Village] Delete alerts
Hi, I am having sround 9 lacs alerts in the eventInBox table. I tried to delete it, It took 4 hrs to delete 1 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]
