Just to repost an entry to undeploy BRE rule a few years back in my another blog. USE [BizTalkRuleEngineDb]GO/****** Object:  StoredProcedure [dbo].[usp_un_rule]    Script Date: 04/27/2009 22:34:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO Create Procedure [dbo].[usp_un_rule](@rulesetName varchar(255),@verMajor int,@verMinor int)AsBeginDECLARE @RuleSetID intSELECT @RuleSetID = nRuleSetIDFROM RE_RulesetWHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor UPDATE RE_RulesetSET nStatus = 0   WHERE nRuleSetID […]