And another BizTalk discovery

Having spent the day dealing with this, I found that I got a vision of the guts of BizTalk.

Obviously not being able to identify where these mysterious schemas were going I decided there was stop mucking around and dig into the tables of the managementDB

Having found what looked like a likely suspect hanging around in the BizTalk.Service application I decided to work out how to dispose of this unwanted scumbag of a dll that was causing me grief!

This led to me finding this blog and after significant checking came up with the following snippet that seems to work on 2006

Give it a shot, it worked for me, but do not come crying if BizTalk no worky...

use BiztalkMgmtDB
go
declare @iAssemblyID int
select @iAssemblyID=nID from bts_assembly where nvcName = 'INSERT DLL NAME HERE'
select @iAssemblyID
delete from bt_mapspec where assemblyid = @iAssemblyID
delete from bt_documentspec where assemblyid = @iAssemblyID
delete from bts_item where assemblyid = @iAssemblyID
delete from bt_properties where nassemblyid = @iAssemblyID
delete from bt_sensitiveproperties where assemblyid = @iAssemblyID
delete from bts_libreference where idlib = @iAssemblyID
delete from bts_assembly where nID = @iAssemblyID