Bring your code 2 life

  This is how a CRM 2011 file menu look like on one of my customer's CRM system. Missing menu items and sometimes wrong translations of dialog contents at the wrong spot gave me headaches for quite some time. After trial and error I checked the patch level of their system. CRM Server was on UR 15 but the Dutch language pack was on UR6 causing such trouble. After installing the Dutch MUI UR 15 language pack update it worked like as it should. Lessions learned: Always check and keep customers patch level of server and language packs on the same level.

Today I tried to migrate a custom CRM 4.0 SQL report to the a CRM 2013 SQL report. In the report designer I hit the preview button and received the following error: TITLE: Microsoft SQL Server Report Designer ------------------------------ An error occurred while executing the query. An insufficient number of arguments were supplied for the procedure or function dbo.fn_GetLocalizedLabel. OK, this means the SQL function "fn_GetLocalizedLabel" in CRM 4.0 used to have one parameter less than in CRM 2011 or CRM 2013. After comparing the paramter signatures with the SQL database version I found this definition: function [ dbo ].[ fn_GetLocalizedLabel ] (     @ ObjectId uniqueidentifier ,     @ ColumnName nvarchar ( 255 ),     @ LabelTypeCode int ,     @ LanguageCode int ) returns nvarchar ( 255 ) as begin     declare @ LocalizedLabel      nvarchar ( 255 )   ...