Plugin Registration Tool 2.0

Plugin registration tool can be fond here:
http://code.msdn.microsoft.com/crmplugin/Release/ProjectReleases.aspx?ReleaseId=90

CRM downloads

all recent downloads :
http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/downloads.aspx

Microsoft Dynamics CRM 4.0 Demonstration Tools :
http://blogs.msdn.com/mscrmfreak/archive/2008/02/04/available-microsoft-dynamics-crm-4-0-demonstration-tools.aspx

download the tool here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=634508DC-1762-40D6-B745-B3BDE05D7012&displaylang=en

Demonstration tool:
http://download.microsoft.com/download/1/5/7/1577a806-a5dd-4f4b-9f48-791dc86c09da/MSDYCRM40_Demonstration%20Tools.exe

Change User language

use sql statement :

update usersettings set UILanguageId = 1037

Problem when activating a Language pack

A Workaround for failure in MUI Provisioning. After installing the language pack and trying to activate the language in the system, you get an error and the event in event viewer is telling this error :

MUI Provisioning failed. Error: Cannot insert duplicate key row in object 'dbo.LocalizedLabel' with unique index 'ndx_LocalizedLabel_ForSingleSelect'.
The statement has been terminated.

the solution is to execute the statement in the organization MSCRM database:

DELETE FROM MetadataSchema.LocalizedLabel WHERE customizationlevel = 2

It seems that the problem was submitted to MS support and there should be a hotfix.

this is taken from these post :
http://blogs.msdn.com/mscrmfreak/archive/2008/02/02/mui-provisioning-failed-workaround.aspx
http://blogs.msdn.com/mscrmfreak/archive/2008/01/10/available-dutch-language-pack-for-microsoft-dynamics-crm-4-0.aspx#7379061 ( look in the comments)

Disabling IIS Loopback Check

An Article that describes the procedure :
Error message when you try to access a server locally by using its FQDN or its CNAME alias after you install Windows Server 2003 Service Pack 1: "Access denied" or "No network provider accepted the given network path"


http://support.microsoft.com/kb/926642

Using CLR Integration in SQL Server 2005

Enabling CLR on sql server 2005 command :
EXEC sp_configure @configname = ’clr enabled’, @configvalue = 1
RECONFIGURE WITH OVERRIDE

Discussion on CLR Integration in SQL Server 2005 benefits and alternatives
http://msdn2.microsoft.com/en-us/library/ms345136.aspx

An Intro to CLR Integration in SQL Server 2005 By Sahil Malik
http://www.developer.com/net/net/article.php/3528601

Simple SQL CLR Integration By Amit Anajwala : Simple how to for begginers
http://www.sqlservercentral.com/articles/Development/simplesqlclrintegration/2023/

Using CLR Integration in SQL 05 for Writing Stored Procedures By Jesse Smith.
http://www.informit.com/articles/article.aspx?p=715008


Series of articles on developer.com By Sahil Malik

1. Writing Database Objects in CLR
http://www.developer.com/net/net/article.php/3548331

2. Writing Database Objects in CLR: Advanced Scenarios
http://www.developer.com/net/net/article.php/3550341

3. Solving the Mysteries of SQLCLR and System.Transactions
http://www.developer.com/net/net/article.php/3556571