Can’t terminate service instance in BizTalk
Well, this method is a bit harsh, but I really needed it terminated. You can look up the Service Instance Id and Service Type Id and execute the following stored procedure on BiztalkMsgBoxDb. Note that this should not be common practice and you should search for the cause of this behavior if it occurs often!
DECLARE @out INT
BEGIN TRANSACTION
exec dbo.int_AdminTerminateInstance_BizTalkServerApplication ‘ServiceInstanceId’, ‘ServiceTypeID’ , @out
COMMIT