Monthly Archive: July 2011


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