Search code examples
dynamics-crm

Dynamics CRM with empty ChangedData rows

As a DBA, I'm studying a little more about our Dynamics CRM and I could see that our auditbase is 160GB.

Inside there's a column called "changedData" and in a lot of them, the row is empty.

  1. Can I create, lets say, an automatic job running a "delete from auditbase where changedData =''"? Is this going to be a problem by not doing it via CRM?

  2. Why is this rows apearing? I could not find this question on the internet, as every site have a different answer.

Solution

  • Directly running DML query in CRM database is unsupported and not recommended.

    If this empty rows are bothering you, then I would recommend you to look into the source issue - which could be plugin code. I researched sometime back and documented in another SO thread for possible reasons, that should give you some clue.