CODEWITHSUNDEEP
dynamics-crm
Racer SQL
Racer SQL

Reputation: 217

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.

Upvotes: 0

Views: 64

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22836

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.

Upvotes: 1

Related Questions