Clear BizTalk Messagebox

Since the release of the CRM - BizTalk connector, you're all doing integrations right? Did it happen to you that you start a BizTalk application one evening and in the morning your messagebox is filled with more then 100.000 instances? If that is the case, then you can delete these by using the BizTalk Administration console. Unfortunately this will take hours and hours..

Instead, running this code on the BizTalk databases solves the issue for you:

DELETE FROM BizTalkMsgBoxDb.Instances
GO
DELETE FROM BizTalkMsgBoxDb.InstancesSuspended
GO

Keep in mind that you should only do this on development, test and acceptation, NEVER on production.