Subject: Losing subscriptions after running the sproc, resulting in complete redeploy of BizTalk application(s).
bts_CleanupMsgBox is not something new and it's been there from BizTalk 2004 SP1. Basically this script is used to clear the MessageBox database (intended only for development and especially useful while during performance testing). This script is not installed by default, the stored procedure will be empty and does nothing. That's how it should be on a production box, ...
[More]