Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on?

I have already covered the Last 100 Messages Received  and the Last 100 Messages Sent queries so what about suspended messages?

In BizTalk 2004 we had a query in HAT to return the last 100 suspended message instances.  Lets create a direct replacement in a BizTalk 2009 Hatless environment.

Basically we are creating a query to search for the last fifty messages that were suspended by BizTalk:

Coming up

Service instances - Last 100