Another nice blog: SQL Statements that tell you why a Deploy won't work, i.e. what maps or pipelines may be used on ports (Eric Stott's blog):

http://blog.biztalk-info.com/archive/2008/03/19
/Having_problems_undeploying_that_pesky_BizTalk_Assembly.aspx