IF (EXISTS (SELECT * FROM [sysobjects] WHERE [name] = 'hst_prodfix_addnew' AND [type] = 'P')) DROP PROCEDURE hst_prodfix_addnew GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE hst_prodfix_addnew @nHostId BIGINT, @nProductId int, @wstrDN [NVARCHAR](256), @strID [varchar] (64), @nOrder [int], @tmTimestamp DATETIME, @nVServerId INT AS SET NOCOUNT ON IF(@strID NOT LIKE N'PDKPATCH_%') BEGIN BEGIN TRANSACTION IF EXISTS(SELECT * FROM Hosts WITH(TABLOCKX, HOLDLOCK) WHERE nId = @nHostId) BEGIN INSERT INTO hst_host_prd_fixes(nHostId, nProductId, wstrDN, strID, nOrder) VALUES (@nHostId, @nProductId, @wstrDN, @strID, @nOrder) EXEC klupd_add_kscp_installed @nHostId, @nProductId, @wstrDN, @strID, @tmTimestamp, @nVServerId; END COMMIT END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO IF (EXISTS (SELECT * FROM [sysobjects] WHERE [name] = 'ptch_fix_old_pdk_patches' AND [type] = 'P')) DROP PROCEDURE ptch_fix_old_pdk_patches GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE ptch_fix_old_pdk_patches AS SET NOCOUNT ON DELETE FROM klupd_update WHERE strKscpUid LIKE N'PDKPATCH_%' GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO EXEC ptch_fix_old_pdk_patches