Hi All,
We have an CRM 2011 on-premise applicaton. We want to delete all the e-mail records with "Pending Send" status. We have queried using advance find and found out that has 5000+ records.
Is there a way to delete the email records in back end (CRM SQL Database)? If yes, please help to create the script.
Thank you all for the help.
*This post is locked for comments
You should use delete jobs. Go to Settings-->Data Management-->Bulk Record Deletion. Use a criteria to select records and run the job.
I don't think it's a good idea to delete a record using SQL in CRM. If you want to delete records using bulk delete functionality of CRM:
Hi,
SQL commands (insert, update, delete) are not supported on MS CRM database.
You should use SDK 's Delete method (msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.delete.aspx)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (