Visual Studio 11 Beta: TFS Express

We have some great stuff coming next week. The Visual Studio 11 Beta is released, and together with it, the TFS Express is a part of the package. This version is free for up to 5 users, and great news for student and for use in private hobby projects 🙂



SQLCMD large script – part 2

I’m in my finale stage in my cleanup project of the 26GB database for a customer. Today, I planned for working late from home. My problem was that my data script had a “use <db name> – included by a mistake. The script files were too large to edit with available tool on the database servere and my broadband connection isn’t good enough to transfer the files between the server and my laptop that has the proper tools.

The solution was a quick look at the SQLCMD command line options. After some frustrating minutes, I spotted the -d <db name> option. I tried it on my local machine and it work perfectly.

As a result, i could load my large script (8gb for largest table) and override the use statement in the script file.


sqlcmd -d <database> -i <script file>


CRM Email Router: enabling logging

Today, I had to debug the CRM Email Router. After some googling I found a easy and simple way of logging the email router as it processes the emails.

  • In the Service folder of Email router installation (C:\Program Files\Microsoft CRM Email\Service), locate the file Microsoft.Crm.Tools.EmailAgent.xml.
  •  There is a key for Log Level – <LogLevel></LogLevel>. Default value is set to 1. Please set it to 3.
  • If it doesn’t exist, add a key for <LogFile>. <LogFile>C:\Temp\EmailRouterLog.txt</LogFile>.
  • Restart the Email router service

Happy debugging…

CRM Email Router: enabling logging (part 2)