Forcing CRM to clean up deleted records

CRM 4.0 tidies up deleted records via the asynchronous service every 24 hours. To force an immediate cleanup follow the steps:

Mark the database to run the deletion tidy up immediately by running the following SQL commands. Take care to update the correct deletion service if your CRM server hosts multiple organizations.

USE MSCRM_CONFIG

UPDATE dbo.ScaleGroupOrganizationMaintenanceJobs// getdate() gets the current date and timeSET NextRunTime = getdate()// Operation Type 14 is the deletion serviceWHERE OperationType = 14

Restart the Microsoft CRM Asynchronous Service.