Delete old cases from CRM 3.0
Use the following query to delete old cases from CRM 3.0.
Set the deletion code value to 2, MS CRM deletion service will automatically delete that records and child records when it will run (usually 2 hours).
Update IncidentBase set deletionStateCode=2
where datediff(d,'2009-06-30',ModifiedOn) < 0
Use the following query to delete old cases from CRM 3.0.
Set the deletion code value to 2, MS CRM deletion service will automatically delete that records and child records when it will run (usually 2 hours).
Update IncidentBase set deletionStateCode=2
where datediff(d,'2009-06-30',ModifiedOn) < 0
No comments:
Post a Comment