Find Orphaned DTA Service Instances with SQL Query
I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how…
Read MoreTag: Microsoft BizTalk
Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails
A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls…
Read MoreHow to Clear or Purge the Biztalk Tracking Database
Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this…
Read MoreCount of Active or Started Messages in BizTalk.
This script will give you a count of active messages within BizTalk. This includes currently processing messages, as well as suspended…
Read MoreSQL Script for suspended message detail in BizTalk
This Script will give you detailed information on suspended message in BizTalk. Run this script against the BizTalkMsgBoxDb.
Read MoreCount of Suspended Messages in BizTalk
This SQL Script will give you the count of all suspended messages in BizTalk. Run this against the BizTalkMsgBoxDb.
Read MoreBizTalk Macros
Here is a list of the File Name Macros. ?You can use a combintation of these to create your file names…
Read MoreStarting BizTalk Server
I am starting on Microsoft BizTalk server today. ?I will be posting information on my progress. ?With my Service Oriented Architecture…
Read More