Hi,

When a record is deleted from application, as i notice, it's still existed
on DB with deletion code = 2.

Since i deleted quite a lot of data from lead and opportunity based on
user's request, can i just delete all garbages from my db which has deletion
code as 2 using query analyzer tools??

Carrie

CRM has a deletion service that will come through eventually and delete the
records. Make sure the service is running on the CRM server.
Microsoft CRM Deletion Service

Don't manually delete the records. The service will also clean up all the
descendent records (ie. Activities) when it cleans up the deleted
leads/opps.



"Carrie" <Carrie@discussions.microsoft.com> wrote in message
news:CCFEC0C0-9668-4A94-952B-9FB4A14D95AE@microsoft.com...

Hi Joe,

Thanks a lot for your info. In addition, i wanna know how often does MSFT
CRM deletion service run in a day??

Can u explain to me why delete record manually is not recommended??

Rgds,
Carrie

"Joe L" wrote:

I deleted a Competitor that had Opportunity records assigned to it without
error or warning. I noticed that the OpportunityCompetitors records are
still in the system and they don't have a special deletion code. Will the
deletion service clean these up as well or should I have deleted the
associations priorto deleting the Competitor?

Thanks,
Ben

"Joe L" wrote: