Change max publish duplicate detection rules

We have an on premise CRM 4.0 rollup 10 deployment, and our client have requested a number of duplicate detection rules upon leads. We started the development of the rules but when we tried to publish then the system informed us that only 5 rules where allowed per entity.

After some googling we found a solution to our problem. In MSCRM_CONFIG database table DeploymentProperties witch holds the constraint of max 5 rules per entity. With a simple query and a full restart of IIS – CRM Asynchronous Service we were able to publish more than 5 rules.

The query for max 7 duplicate detection rules was:

update DeploymentProperties set

      IntColumn = 7

where ColumnName = 'DupMaxPublishedRules'

The above solution is not supported by Microsoft and can cause serious performance issues, but in our case (the number of leads is relatively small) we didn’t have any problem.

Deserialization failed: The 'DataType' attribute is not declared

I faced the above problem when I tried to open a report in Visual Studio 2008. I had edited the report many times in the past and I don’t know what caused the problem. In my opinion it must be a bug of the report builder of Visual Studio 2008. I opened the xml definition of the report and compared it with a version of the report witch was working. The difference can be found below.

Working xml

      <ValidValues>

        <ParameterValues>

          <ParameterValue>

            <Value>-1</Value>

            <Label>Less Than</Label>

          </ParameterValue>

          <ParameterValue>

            <Value>0</Value>

            <Label>Equal</Label>

          </ParameterValue>

          <ParameterValue>

            <Value>1Value>

            <Label>Greater Than</Label>

          </ParameterValue>

        </ParameterValues>

      </ValidValues>

Not working xml

      <ValidValues>

        <ParameterValues>

          <ParameterValue>

            <Value DataType="Integer">-1</Value>

            <Label>Less Than</Label>

          </ParameterValue>

          <ParameterValue>

            <Value DataType="Integer">0</Value>

            <Label>Equal</Label>

          </ParameterValue>

          <ParameterValue>

            <Value DataType="Integer">1</Value>

            <Label>Greater Than</Label>

          </ParameterValue>

        </ParameterValues>

      </ValidValues>

I removed the DataType attribute and everything worked fine

Sql2k8 (x64) fails on PassPidBackFromComponentUpdate 0x80070006 (E_HANDLE)

We were trying to install sql server 2008 from an MSDN subscription and we got an error message 0x80070006 (E_HANDLE). After some googling we found that is a MSDN bug and the solution to the problem was in the product key selection to simply select the "Specify a free edition" radio button without changing the shown PID, then reselect the "Enter the product key" radio button (again without changing the PID). That was crazy... The original post of the solution can be found here.