Monday, August 29, 2011

CRM 4.0 - detach answered email from queue

One of my customers requested following functionality - detach email from queue when email is answered.

Solution consists of 2 parts - customization of email (addition of source email field and JavaScipt which will extract id of source email) and Plugin which will handle Send message.

Sunday, August 28, 2011

Microsoft SQL - How to attach database having only mdf file

Quick trick - I had only mdf file of database without log file. Following t-sql script allowed me to attach mdf file to SQL:

sp_attach_single_file_db @dbname= 'NewDatabase', @physname= 'C:\Directory\DataBase.mdf'


After I ran this script I have got several messages but database was restored and worked fine.

Thursday, August 25, 2011

CRM 4.0 - supported way to use stored procedures in reports

It is written in SDK that it is possible to use Stored Procedures in reports and following article will describe how to do it.

CRM 4.0 - Create new Organization failed with Exception: System.UnauthorizedAccessException: Access is denied

I tried to create new organization at one test environment and I have got following error:


Tuesday, August 02, 2011