use [Enterprise Manager]
--  
-- Script to Update dbo.AP Invoices in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AP Invoices Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_AP Invoices_7_2043154324__K9_K1_K8] ON [dbo].[AP Invoices] ([Non-Purchase Flag], [ID], [Void Flag])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AP Invoices Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AP Invoices Table'
END
GO


--  
-- Script to Update dbo.AP Invoices Item Charges in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AP Invoices Item Charges Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_AP Invoices Item Charges_7_2075154438__K6_K3_K2_5] ON [dbo].[AP Invoices Item Charges] ([Unit Cost], [AP Invoices ID], [Ordered ID]) INCLUDE ([Qty Invoiced])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AP Invoices Item Charges Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AP Invoices Item Charges Table'
END
GO


--  
-- Script to Update dbo.AR Recv Invoice Items in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AR Recv Invoice Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_AR Recv Invoice Items_7_392388467__K16_K2_3_14] ON [dbo].[AR Recv Invoice Items] ([SKU ID], [Invoice ID]) INCLUDE ([Qty Invoiced], [Qty Picked Up])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_392388467_2_16] ON [dbo].[AR Recv Invoice Items] ([Invoice ID], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AR Recv Invoice Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AR Recv Invoice Items Table'
END
GO


--  
-- Script to Update dbo.AR Recv Invoices in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AR Recv Invoices Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_AR Recv Invoices_7_134291538__K2_K1_K3] ON [dbo].[AR Recv Invoices] ([Contract], [ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AR Recv Invoices Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AR Recv Invoices Table'
END
GO


--  
-- Script to Update dbo.Associated Materials in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Associated Materials Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Associated Materials_7_41767206__K5_K1] ON [dbo].[Associated Materials] ([SKU ID], [Association ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Associated Materials Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Associated Materials Table'
END
GO


--  
-- Script to Update dbo.EM Job Hardware in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Hardware Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_11_2_12_1] ON [dbo].[EM Job Hardware] ([Associated Material ID], [Assembly ID], [CNC Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_1_9] ON [dbo].[EM Job Hardware] ([ID], [UOM ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_2_12_1] ON [dbo].[EM Job Hardware] ([Assembly ID], [CNC Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_9_2_12_1] ON [dbo].[EM Job Hardware] ([UOM ID], [Assembly ID], [CNC Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Hardware Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Hardware Table'
END
GO


--  
-- Script to Update dbo.EM Job Sheet Goods in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Sheet Goods Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   ALTER TABLE [dbo].[EM Job Sheet Goods]
      ADD [No Labels Flag] [bit] NULL
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Sheet Goods Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Sheet Goods Table'
END
GO


--  
-- Script to Update dbo.EM Task Parts in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Task Parts Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_EM Task Parts_7_816721962__K2_K3] ON [dbo].[EM Task Parts] ([Job Tasks ID], [Job Assemblies ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Task Parts Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Task Parts Table'
END
GO


--  
-- Script to Update dbo.FWPSTOCK in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.FWPSTOCK Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_776389835_15_22_1_3_4] ON [dbo].[FWPSTOCK] ([Inactive], [Stock Flag], [SKU ID], [CATEGORY], [Sub Category])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_776389835_1_15] ON [dbo].[FWPSTOCK] ([SKU ID], [Inactive])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_776389835_3_4_7_1_15_22] ON [dbo].[FWPSTOCK] ([CATEGORY], [Sub Category], [Vendor Description], [SKU ID], [Inactive], [Stock Flag])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.FWPSTOCK Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.FWPSTOCK Table'
END
GO


--  
-- Script to Update dbo.Purchase Order Items in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Purchase Order Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Purchase Order Items_7_712389607__K14_K1_K3] ON [dbo].[Purchase Order Items] ([SKU ID], [ID], [VENDOR CODE])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_712389607_14_3_10] ON [dbo].[Purchase Order Items] ([SKU ID], [VENDOR CODE], [PO ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Purchase Order Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Purchase Order Items Table'
END
GO


--  
-- Script to Update dbo.Purchase Orders in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Purchase Orders Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Purchase Orders_7_1495676376__K2_K7_K1] ON [dbo].[Purchase Orders] ([PO Number], [Date Issued], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1495676376_1_2] ON [dbo].[Purchase Orders] ([ID], [PO Number])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Purchase Orders Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Purchase Orders Table'
END
GO


--  
-- Script to Update dbo.Scanning Session Items in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Scanning Session Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Scanning Session Items_7_310292165__K4_K5_K2_6] ON [dbo].[Scanning Session Items] ([Item Type], [Item ID], [Session ID]) INCLUDE ([Qty Scanned])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_310292165_2_4_5] ON [dbo].[Scanning Session Items] ([Session ID], [Item Type], [Item ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_310292165_2_5] ON [dbo].[Scanning Session Items] ([Session ID], [Item ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_310292165_5_4] ON [dbo].[Scanning Session Items] ([Item ID], [Item Type])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Scanning Session Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Scanning Session Items Table'
END
GO


--  
-- Script to Update dbo.Scanning Sessions in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Scanning Sessions Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Scanning Sessions_7_589245154__K2_K6_K1] ON [dbo].[Scanning Sessions] ([Session Type], [Session Target ID], [Session ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_589245154_1_2] ON [dbo].[Scanning Sessions] ([Session ID], [Session Type])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_589245154_1_6] ON [dbo].[Scanning Sessions] ([Session ID], [Session Target ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Scanning Sessions Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Scanning Sessions Table'
END
GO


--  
-- Script to Update dbo.Shipment Items in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Shipment Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Shipment Items_7_1607676775__K3_K1_K8_K2_5] ON [dbo].[Shipment Items] ([Location ID], [ID], [Location Table ID], [Shipments ID]) INCLUDE ([Item Qty])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1607676775_2_1_3] ON [dbo].[Shipment Items] ([Shipments ID], [ID], [Location ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Shipment Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Shipment Items Table'
END
GO


--  
-- Script to Update dbo.Shipments in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Shipments Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_Shipments_7_1687677060__K1_14] ON [dbo].[Shipments] ([ID]) INCLUDE ([Complete])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1687677060_14_1] ON [dbo].[Shipments] ([Complete], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Shipments Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Shipments Table'
END
GO


--  
-- Script to Create dbo.tbl Manufacturing Pinned Actions in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Creating dbo.tbl Manufacturing Pinned Actions Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO

CREATE TABLE [dbo].[tbl Manufacturing Pinned Actions] (
   [Manufacturing Pinned Action ID] [int] IDENTITY (1, 1) NOT NULL,
   [User ID] [int] NULL,
   [Created DateTime] [datetime] NULL,
   [Task ID] [int] NULL,
   [Filename] [nvarchar] (255) NULL,
   [Action Name] [nvarchar] (50) NULL
)
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.tbl Manufacturing Pinned Actions Table Added Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Add dbo.tbl Manufacturing Pinned Actions Table'
END
GO


--  
-- Script to Update dbo.tbl Vendor to SKU Map in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.tbl Vendor to SKU Map Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_tbl Vendor to SKU Map_7_536388980__K2_K9_K3_4_5_12_13] ON [dbo].[tbl Vendor to SKU Map] ([SKU ID], [PRIMARY FLAG], [VENDOR ID]) INCLUDE ([VENDOR ITEM NUMBER], [VENDOR COST], [VENDOR PACK SIZE], [VENDOR MUST BUY])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_536388980_2_3_9] ON [dbo].[tbl Vendor to SKU Map] ([SKU ID], [VENDOR ID], [PRIMARY FLAG])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_536388980_9_2] ON [dbo].[tbl Vendor to SKU Map] ([PRIMARY FLAG], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.tbl Vendor to SKU Map Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.tbl Vendor to SKU Map Table'
END
GO


--  
-- Script to Update dbo.VENDORS in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.VENDORS Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE INDEX [_dta_index_VENDORS_7_738817694__K1_K2] ON [dbo].[VENDORS] ([ID], [VENDOR CODE])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_738817694_2_1] ON [dbo].[VENDORS] ([VENDOR CODE], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.VENDORS Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.VENDORS Table'
END
GO


--  
-- Script to Update dbo.view: Sheet Good Details in fwpsrv.Enterprise Manager build 1334 
-- Generated Thursday, February 16, 2012, at 10:22 AM 
--  
-- Please backup fwpsrv.Enterprise Manager build 1334 before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.view: Sheet Good Details View'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


exec('ALTER VIEW [dbo].[view: Sheet Good Details]
AS
SELECT     ID, [Job Tasks ID], [Code Stored Files ID], Thickness, Width, Length, Complete, [CW Material ID], [Offcut ID], [Date Added], [Machine ID], SSMA_TimeStamp, 
                      [Do Not Remove Comments Flag], [SKU ID], [From Inventory Flag], Source, [Source ID], [Material Name ID], [Material Up Face ID], [Material Down Face ID], 
                      [Up Face Description], [Down Face Description], [Stock Flag], (CASE WHEN [Up Face Description] IS NOT NULL AND [Down Face Description] IS NOT NULL 
                      THEN REPLACE(REPLACE([Display Name Temp], ''[Top Face]'', [UP Face Description]), ''[Bottom Face]'', [Down Face Description]) ELSE [Display Name Temp] END) 
                      AS [Display Name], [Material Name], [6th Face Code Stored Files ID], [Has Grain Flag], [Material Up Face RGB], [Material Down Face RGB], [No Labels Flag]
FROM         (SELECT     TOP 100 PERCENT dbo.[EM Job Sheet Goods].ID, dbo.[EM Job Sheet Goods].[Job Tasks ID], dbo.[EM Job Sheet Goods].[Code Stored Files ID], 
                                              dbo.[EM Job Sheet Goods].Thickness, dbo.[EM Job Sheet Goods].Width, dbo.[EM Job Sheet Goods].Length, dbo.[EM Job Sheet Goods].Complete, 
                                              dbo.[EM Job Sheet Goods].[CW Material ID], dbo.[EM Job Sheet Goods].[Offcut ID], dbo.[EM Job Sheet Goods].[Date Added], 
                                              dbo.[EM Job Sheet Goods].[Machine ID], dbo.[EM Job Sheet Goods].SSMA_TimeStamp, dbo.[EM Job Sheet Goods].[Do Not Remove Comments Flag], 
                                              dbo.[EM Job Sheet Goods].[SKU ID], dbo.[EM Job Sheet Goods].[From Inventory Flag], dbo.[EM Job Sheet Goods].Source, 
                                              dbo.[EM Job Sheet Goods].[Source ID], dbo.[EM Job Sheet Goods].[Material Name ID], dbo.[EM Job Sheet Goods].[Material Up Face ID], 
                                              dbo.[EM Job Sheet Goods].[Material Down Face ID], dbo.[EM Job Sheet Goods].[Material Up Face RGB], 
                                              dbo.[EM Job Sheet Goods].[Material Down Face RGB],
                                                  (SELECT     [Face Description]
                                                    FROM          dbo.[EM Job Sheet Goods Face Descriptions]
                                                    WHERE      ([Face ID] = dbo.[EM Job Sheet Goods].[Material Up Face ID])) AS [Up Face Description],
                                                  (SELECT     [Face Description]
                                                    FROM          dbo.[EM Job Sheet Goods Face Descriptions] AS [EM Job Sheet Goods Face Descriptions_1]
                                                    WHERE      ([Face ID] = dbo.[EM Job Sheet Goods].[Material Down Face ID])) AS [Down Face Description], dbo.FWPSTOCK.[Stock Flag], 
                                              (CASE WHEN [Force Use Material Name] = 1 THEN [Material Name] ELSE (CASE WHEN [Vendor Description] IS NOT NULL 
                                              THEN [Vendor Description] ELSE [Material Name] END) END) AS [Display Name Temp], dbo.FWPSTOCK.[Vendor Description], 
                                              dbo.[EM Job Sheet Goods].[Material Name], dbo.[EM Job Sheet Goods].[6th Face Code Stored Files ID], dbo.[EM Job Sheet Goods].[Has Grain Flag], 
                                              dbo.[EM Job Sheet Goods].[No Labels Flag]
                       FROM          dbo.[EM Job Sheet Goods] LEFT OUTER JOIN
                                              dbo.FWPSTOCK ON dbo.[EM Job Sheet Goods].[SKU ID] = dbo.FWPSTOCK.[SKU ID]
                       ORDER BY dbo.[EM Job Sheet Goods].ID DESC) AS derivedtbl_1
')
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.view: Sheet Good Details View Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.view: Sheet Good Details View'
END
GO