Bulk Edit

Friday, January 25th, 2008

We have noticed that it is not possible to bulk edit fields with onChange scripts enabled on the field.

Microsoft descibes a workaround for this in their article: The fields that have the OnChange event enabled are unavailable in the Edit Multiple Records window in Microsoft Dynamics CRM 4.0.

Upgrade Problems

Thursday, January 17th, 2008

Some foreign key constraints on custom entity tables are missing after you upgrade to Microsoft Dynamics CRM 4.0
Consider the following scenario. You have a custom entity table, and the custom entity table has a primary key constraint and a foreign key constraint on the same column. When you upgrade to Microsoft Dynamics CRM 4.0, the foreign key constraint is removed during the upgrade process.

For example, assume that you have a custom entity table that is called AuditTrailExtensionBase. The following foreign key is added.

ALTER TABLE [dbo].[<databasename>_AuditTrailExtensionBase] ADD CONSTRAINT [FK_<databasename>_AuditTrailExtensionBase_<Databasename>_AuditTrailBase] FOREIGN KEY ([<databasename>_AuditTrailId]) REFERENCES [dbo].[<databasename>_AuditTrailBase] ([<databasename>_AuditTrailId])

After the upgrade process is complete, this foreign key is no longer present.
To resolve this problem, add the missing foreign key constraint to the custom entity table.

(source: http://support.microsoft.com/kb/947061)