Zombie identification in Biztalk 2006

Zombies can be identified in Biztalk server 2006 by using the following query in the messagebox database.

SELECT * FROM HostNameQ_Suspended where nErrorCategory = 4


In the above query HostName should be replaced with corresponding host name in which you want to identify the Zombies. If the above query return any rows then it indicates that there are Zombies present.