MS CRM 2011: Sql Timeouts during access to views

Yesterday we have deployed solution on productive system and imported data – about 40 millions of records in different entities. During testing “Generic Sql Exception” messages begun appear for some types of records.

Integrating CRM 2011 using SQL Integration Services (SSIS)

I read this article and decided to make something similar for CRM 2011. You can see results in this post.

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.

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 Usage Report

One of customer wanted to have the possibility to see who and when was working in CRM. I knew that MVP David Jennaway had created such solution based on IIS's logs. No matter how I tried - I failed to implement it. Logs weren't written to log database. Also this approach doesn't work in IFD deployment scenario.

So I left this idea and begun develop own solution.

Отображение денежных единиц в отчётах прописью

Этот пост пишу по-русски, потому что он может быть интересен только русскоязычным читателям.

При разработке отчётов-печатных форм счёта столкнулся с необходимостью выводить величину счёта буквами (125 руб. 50 коп надо было отобразить соответственно Сто двадцать пять рублей 50 копеек). Для этого, произведя поиск, нашёл и использовал следующие функции, которые могут пригодиться и Вам. Далее код: