Geeks With Blogs
Tommy Wang April 2009 Entries
SQL script to undeploy rules/vocabularies
USE [BizTalkRuleEngineDb] GO /****** Object: StoredProcedure [dbo].[usp_un_rule] Script Date: 04/27/2009 22:34:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create Procedure [dbo].[usp_un_rule] ( @rulesetName varchar(255), @verMajor int, @verMinor int ) As Begin DECLARE @RuleSetID int SELECT @RuleSetID = nRuleSetID FROM RE_Ruleset WHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor UPDATE RE_Ruleset SET nStatus = 0 WHERE nRuleSetID = @RuleSetID DELETE FROM re_deployment_config ......

Posted On Tuesday, April 28, 2009 11:03 AM

Copyright © twang | Powered by: