Here's a sql script I use against the BizTalkMgmtDb when I'm debugging issues that I think are caused by botched deployments: SELECT nvcName AS AssemblyName, nvcVersion AS Version, DATEADD(hh, DATEDIFF(hh, GetUTCDate(), GETDATE()), dtDateModified) AS...