2014.8.29.1 Upgrade Steps

1) Execute the following SQL Script on the APS_Publish Database. This will add ClearAllHistoryData and ClearOldHistoryData Stored Procedures to the database. /****** Object: StoredProcedure [dbo].[ClearAllHistoryData] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= CREATE PROCEDURE [dbo].[ClearAllHistoryData] @PublishInventory bit, @PublishCapacityIntervals bit AS BEGIN IF @PublishInventory = 1 BEGIN DELETE FROM JobProductSalesOrderDemands; DELETE FROM […]

Read More