Share via

URGENT !!! Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max)....

  • Article
  • 09/01/2015

Question

Tuesday, September 1, 2015 8:01 AM

USE [Auto_20150701]
GO

/****** Object:  Table [dbo].[TransactionLine7]    Script Date: 1.9.2015 10:54:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create TABLE [dbo].[TransactionLine7](
[OID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Active] [int] NULL,
[CreatedOn] [datetime] NULL,
[CreatedBy] [uniqueidentifier] NULL,
[LastModifiedOn] [datetime] NULL,
[LastModifiedBy] [uniqueidentifier] NULL,
[LastLogoFeedBack] [datetime] NULL,
[LogicalRef] [int] NULL,
[LogoImportTime] [datetime] NULL,
[LogoExportTime] [datetime] NULL,
[LineNumber] [int] NULL,
[LineType] [int] NULL,
[ItemID] [int] NULL,
[UnitID] [int] NULL,
[UnitConv1] [float] NULL,
[UnitConv2] [float] NULL,
[Amount] [float] NULL,
[Price] [float] NULL,
[Total] [float] NULL,
[VatRate] [float] NULL,
[SpecialCode] [nvarchar](100) NULL,
[DeliveryCode] [nvarchar](100) NULL,
[SourceWarehouseID] [int] NULL,
[Description] [nvarchar](100) NULL,
[TransactionID] [int] NULL,
[InvoiceID] [int] NULL,
[VariantID] [int] NULL,
[CostRate] [float] NULL,
[DestinationWarehouseID] [int] NULL,
[LogoProductionOrderLineRef] [int] NULL,
[PayPlanID] [int] NULL,
[OrderLine] [int] NULL,
[DependedTransactionLineID] [int] NULL,
[ControlStatus] [int] NULL,
[ControlQuantity] [int] NULL,
[OptimisticLockField] [int] NULL,
[CaseStockCardID] [int] NULL,
[CaseAmount] [float] NULL,
[CaseRequiredAmount] [float] NULL,
[UserDefinedSalesDispatchLineID] [int] NULL,
[UnitSetID] [int] NULL,
[Percent] [float] NULL,
[Currency] [int] NULL,
[CurrencyRate] [float] NULL,
[GLAccountID] [int] NULL,
[ExpenseCenterID] [int] NULL,
[ProjectID] [int] NULL,
[DueDate] [datetime] NULL,
[DetailedDescription] [nvarchar](max) NULL,
[OutputCode] [nvarchar](100) NULL,
[ReturnCostType] [int] NULL,
[CollateralAffectRisk] [bit] NULL,
[AffectRisk] [bit] NULL,
[Locked] [bit] NULL,
[ActiveUser] [uniqueidentifier] NULL,
[ConvFactor1] [float] NULL,
[ConvFactor2] [float] NULL,
[QualityControlForm] [uniqueidentifier] NULL,
[LaboratoryTestResultID] [int] NULL,
[SpecialCode1] [nvarchar](10) NULL,
[SpecialCode2] [nvarchar](10) NULL,
[SpecialCode3] [nvarchar](10) NULL,
[SpecialCode4] [nvarchar](10) NULL,
[SpecialCode5] [nvarchar](10) NULL,
[SpecialCode6] [nvarchar](10) NULL,
[SpecialCode7] [nvarchar](10) NULL,
[SpecialCode8] [nvarchar](10) NULL,
[SpecialCode9] [nvarchar](10) NULL,
[SpecialCode10] [nvarchar](10) NULL,
[SpecialValue1] [float] NULL,
[SpecialValue2] [float] NULL,
[SpecialValue3] [float] NULL,
[SpecialValue4] [float] NULL,
[SpecialValue5] [float] NULL,
[SpecialValue6] [float] NULL,
[SpecialValue7] [float] NULL,
[SpecialValue8] [float] NULL,
[SpecialValue9] [float] NULL,
[SpecialValue10] [float] NULL,
[SpecialDate1] [datetime] NULL,
[SpecialDate2] [datetime] NULL,
[SpecialDate3] [datetime] NULL,
[SpecialDate4] [datetime] NULL,
[SpecialDate5] [datetime] NULL,
[SpecialDate6] [datetime] NULL,
[SpecialDate7] [datetime] NULL,
[SpecialDate8] [datetime] NULL,
[SpecialDate9] [datetime] NULL,
[SpecialDate10] [datetime] NULL,
[PackageID] [int] NULL,
[WorkOrderID] [int] NULL,
[IsPeriodLocked] [bit] NULL,
[ShippedDate] [datetime] NULL,
[PLAmount] [float] NULL,
[ShippedAmount] [float] NULL,
[ShippingStatus] [int] NULL,
[ShippedTransactionLineID] [int] NULL,
[DemandingFicheLine] [int] NULL,
[subcontractorDemanFicheLineID ] [int] NULL,
[PackagingFicheID] [int] NULL,
[TransferFicheLineID] [int] NULL,
[LastControl] [bit] NULL,
 CONSTRAINT [PK_TransactionLine7] PRIMARY KEY CLUSTERED 
(
[OID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

I need to create and convert this to in memory optimized but I cannot create it.When I create it got an error :

Msg 1709, Level 16, State 1, Line 11
Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM varbinary(max), xml or large CLR type columns.

In the text which is typed bold,There is a nvarchar(max) which is not supported sql server 2014.Also this column is null.I converted max to 100.I already got this error message.How can I fix this problem.

Thanks.

All replies (4)

Tuesday, September 1, 2015 8:44 AM ✅Answered

Msg 1709, Level 16, State 1, Line 11
Cannot use TEXTIMAGE_ON when a table has no text, ....

Then remove the "TEXTIMAGE_ON [PRIMARY] " part from the CREATE Statement.

Olaf Helper

[ Blog] [ Xing] [ MVP]

Tuesday, September 1, 2015 8:55 AM

Hi Ceakn,

 This is an unexpected behavior by design. I don't know if there will be a change in further releases but here is the work-around:

http://blogs.msdn.com/duncand/archive/2007/01/27/datadude-and-the-text-filegroup.aspx

Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

Tuesday, September 1, 2015 8:57 AM

Tried running your script and its working with no problem,

you can remove the "TEXTIMAGE_ON [Primary]" from the script, you need it only if you are want to save the nvarchar(max) data FileGroup other then the primary 

Are you using paritions on the table? can you send the DB creation script as well?

 Guy Twena

Tuesday, September 1, 2015 10:57 AM

USE [X_20150701]
GO

/****** Object:  Table [dbo].[TransactionLine5]    Script Date: 1.9.2015 13:51:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TransactionLine5]
(
[OID] [int] IDENTITY(1,1) NOT NULL,
[Active] [int] NULL,
[CreatedOn] [datetime] NULL,
[CreatedBy] [uniqueidentifier] NULL,
[LastModifiedOn] [datetime] NULL,
[LastModifiedBy] [uniqueidentifier] NULL,
[LastLogoFeedBack] [datetime] NULL,
[LogicalRef] [int] NULL,
[LogoImportTime] [datetime] NULL,
[LogoExportTime] [datetime] NULL,
[LineNumber] [int] NULL,
[LineType] [int] NULL,
[ItemID] [int] NULL,
[UnitID] [int] NULL,
[UnitConv1] [float] NULL,
[UnitConv2] [float] NULL,
[Amount] [float] NULL,
[Price] [float] NULL,
[Total] [float] NULL,
[VatRate] [float] NULL,
[SpecialCode] [nvarchar](100) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[DeliveryCode] [nvarchar](100) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SourceWarehouseID] [int] NULL,
[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[TransactionID] [int] NULL,
[InvoiceID] [int] NULL,
[VariantID] [int] NULL,
[CostRate] [float] NULL,
[DestinationWarehouseID] [int] NULL,
[LogoProductionOrderLineRef] [int] NULL,
[PayPlanID] [int] NULL,
[OrderLine] [int] NULL,
[DependedTransactionLineID] [int] NULL,
[ControlStatus] [int] NULL,
[ControlQuantity] [int] NULL,
[OptimisticLockField] [int] NULL,
[CaseStockCardID] [int] NULL,
[CaseAmount] [float] NULL,
[CaseRequiredAmount] [float] NULL,
[UserDefinedSalesDispatchLineID] [int] NULL,
[UnitSetID] [int] NULL,
[Percent] [float] NULL,
[Currency] [int] NULL,
[CurrencyRate] [float] NULL,
[GLAccountID] [int] NULL,
[ExpenseCenterID] [int] NULL,
[ProjectID] [int] NULL,
[DueDate] [datetime] NULL,
[DetailedDescription] [nvarchar](100) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[OutputCode] [nvarchar](100) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[ReturnCostType] [int] NULL,
[CollateralAffectRisk] [bit] NULL,
[AffectRisk] [bit] NULL,
[Locked] [bit] NULL,
[ActiveUser] [uniqueidentifier] NULL,
[ConvFactor1] [float] NULL,
[ConvFactor2] [float] NULL,
[QualityControlForm] [uniqueidentifier] NULL,
[LaboratoryTestResultID] [int] NULL,
[SpecialCode1] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode2] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode3] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode4] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode5] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode6] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode7] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode8] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode9] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialCode10] [nvarchar](10) COLLATE SQL_Latin1_General_CP1254_CI_AS NULL,
[SpecialValue1] [float] NULL,
[SpecialValue2] [float] NULL,
[SpecialValue3] [float] NULL,
[SpecialValue4] [float] NULL,
[SpecialValue5] [float] NULL,
[SpecialValue6] [float] NULL,
[SpecialValue7] [float] NULL,
[SpecialValue8] [float] NULL,
[SpecialValue9] [float] NULL,
[SpecialValue10] [float] NULL,
[SpecialDate1] [datetime] NULL,
[SpecialDate2] [datetime] NULL,
[SpecialDate3] [datetime] NULL,
[SpecialDate4] [datetime] NULL,
[SpecialDate5] [datetime] NULL,
[SpecialDate6] [datetime] NULL,
[SpecialDate7] [datetime] NULL,
[SpecialDate8] [datetime] NULL,
[SpecialDate9] [datetime] NULL,
[SpecialDate10] [datetime] NULL,
[PackageID] [int] NULL,
[WorkOrderID] [int] NULL,
[IsPeriodLocked] [bit] NULL,
[ShippedDate] [datetime] NULL,
[PLAmount] [float] NULL,
[ShippedAmount] [float] NULL,
[ShippingStatus] [int] NULL,
[ShippedTransactionLineID] [int] NULL,
[DemandingFicheLine] [int] NULL,
[subcontractorDemanFicheLineID ] [int] NULL,
[PackagingFicheID] [int] NULL,
[TransferFicheLineID] [int] NULL,
[LastControl] [bit] NULL,

CONSTRAINT [TransactionLine5_primaryKey] PRIMARY KEY NONCLUSTERED 
(
[OID] ASC
)
)WITH ( MEMORY_OPTIMIZED = ON , DURABILITY = SCHEMA_AND_DATA )

GO

By the way,there are 2 million row in this table.Before optimization select * from TransactionLine 5 is completed around 3 minutes.After memory optimization it is completed in 1.38 min.Actualy 40% of performances.In microsoft presentation It is called up to 100X.Is there anything did I do wrong.

the code before optimization:

/*

USE [Autoneum_coralreef_20150701]
GO

/****** Object:  Table [dbo].[TransactionLine]    Script Date: 1.9.2015 13:56:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TransactionLine](
[OID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Active] [int] NULL,
[CreatedOn] [datetime] NULL,
[CreatedBy] [uniqueidentifier] NULL,
[LastModifiedOn] [datetime] NULL,
[LastModifiedBy] [uniqueidentifier] NULL,
[LastLogoFeedBack] [datetime] NULL,
[LogicalRef] [int] NULL,
[LogoImportTime] [datetime] NULL,
[LogoExportTime] [datetime] NULL,
[LineNumber] [int] NULL,
[LineType] [int] NULL,
[ItemID] [int] NULL,
[UnitID] [int] NULL,
[UnitConv1] [float] NULL,
[UnitConv2] [float] NULL,
[Amount] [float] NULL,
[Price] [float] NULL,
[Total] [float] NULL,
[VatRate] [float] NULL,
[SpecialCode] [nvarchar](100) NULL,
[DeliveryCode] [nvarchar](100) NULL,
[SourceWarehouseID] [int] NULL,
[Description] [nvarchar](100) NULL,
[TransactionID] [int] NULL,
[InvoiceID] [int] NULL,
[VariantID] [int] NULL,
[CostRate] [float] NULL,
[DestinationWarehouseID] [int] NULL,
[LogoProductionOrderLineRef] [int] NULL,
[PayPlanID] [int] NULL,
[OrderLine] [int] NULL,
[DependedTransactionLineID] [int] NULL,
[ControlStatus] [int] NULL,
[ControlQuantity] [int] NULL,
[OptimisticLockField] [int] NULL,
[CaseStockCardID] [int] NULL,
[CaseAmount] [float] NULL,
[CaseRequiredAmount] [float] NULL,
[UserDefinedSalesDispatchLineID] [int] NULL,
[UnitSetID] [int] NULL,
[Percent] [float] NULL,
[Currency] [int] NULL,
[CurrencyRate] [float] NULL,
[GLAccountID] [int] NULL,
[ExpenseCenterID] [int] NULL,
[ProjectID] [int] NULL,
[DueDate] [datetime] NULL,
[DetailedDescription] [nvarchar](max) NULL,
[OutputCode] [nvarchar](100) NULL,
[ReturnCostType] [int] NULL,
[CollateralAffectRisk] [bit] NULL,
[AffectRisk] [bit] NULL,
[Locked] [bit] NULL,
[ActiveUser] [uniqueidentifier] NULL,
[ConvFactor1] [float] NULL,
[ConvFactor2] [float] NULL,
[QualityControlForm] [uniqueidentifier] NULL,
[LaboratoryTestResultID] [int] NULL,
[SpecialCode1] [nvarchar](10) NULL,
[SpecialCode2] [nvarchar](10) NULL,
[SpecialCode3] [nvarchar](10) NULL,
[SpecialCode4] [nvarchar](10) NULL,
[SpecialCode5] [nvarchar](10) NULL,
[SpecialCode6] [nvarchar](10) NULL,
[SpecialCode7] [nvarchar](10) NULL,
[SpecialCode8] [nvarchar](10) NULL,
[SpecialCode9] [nvarchar](10) NULL,
[SpecialCode10] [nvarchar](10) NULL,
[SpecialValue1] [float] NULL,
[SpecialValue2] [float] NULL,
[SpecialValue3] [float] NULL,
[SpecialValue4] [float] NULL,
[SpecialValue5] [float] NULL,
[SpecialValue6] [float] NULL,
[SpecialValue7] [float] NULL,
[SpecialValue8] [float] NULL,
[SpecialValue9] [float] NULL,
[SpecialValue10] [float] NULL,
[SpecialDate1] [datetime] NULL,
[SpecialDate2] [datetime] NULL,
[SpecialDate3] [datetime] NULL,
[SpecialDate4] [datetime] NULL,
[SpecialDate5] [datetime] NULL,
[SpecialDate6] [datetime] NULL,
[SpecialDate7] [datetime] NULL,
[SpecialDate8] [datetime] NULL,
[SpecialDate9] [datetime] NULL,
[SpecialDate10] [datetime] NULL,
[PackageID] [int] NULL,
[WorkOrderID] [int] NULL,
[IsPeriodLocked] [bit] NULL,
[ShippedDate] [datetime] NULL,
[PLAmount] [float] NULL,
[ShippedAmount] [float] NULL,
[ShippingStatus] [int] NULL,
[ShippedTransactionLineID] [int] NULL,
[DemandingFicheLine] [int] NULL,
[subcontractorDemanFicheLineID ] [int] NULL,
[PackagingFicheID] [int] NULL,
[TransferFicheLineID] [int] NULL,
[LastControl] [bit] NULL,
 CONSTRAINT [PK_TransactionLine] PRIMARY KEY CLUSTERED 
(
[OID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_CaseStockCardID] FOREIGN KEY([CaseStockCardID])
REFERENCES [dbo].[Items] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_CaseStockCardID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_DemandingFicheLine] FOREIGN KEY([DemandingFicheLine])
REFERENCES [dbo].[DemandingFicheLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_DemandingFicheLine]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_DependedTransactionLineID] FOREIGN KEY([DependedTransactionLineID])
REFERENCES [dbo].[TransactionLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_DependedTransactionLineID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_DestinationWarehouseID] FOREIGN KEY([DestinationWarehouseID])
REFERENCES [dbo].[Warehouse] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_DestinationWarehouseID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_ExpenseCenterID] FOREIGN KEY([ExpenseCenterID])
REFERENCES [dbo].[ExpenseCenter] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_ExpenseCenterID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_GLAccountID] FOREIGN KEY([GLAccountID])
REFERENCES [dbo].[GLAccount] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_GLAccountID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_InvoiceID] FOREIGN KEY([InvoiceID])
REFERENCES [dbo].[Invoice] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_InvoiceID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_ItemID] FOREIGN KEY([ItemID])
REFERENCES [dbo].[Items] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_ItemID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_LaboratoryTestResultID] FOREIGN KEY([LaboratoryTestResultID])
REFERENCES [dbo].[LaboratoryTestResult] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_LaboratoryTestResultID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_OrderLine] FOREIGN KEY([OrderLine])
REFERENCES [dbo].[OrderLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_OrderLine]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_PackageID] FOREIGN KEY([PackageID])
REFERENCES [dbo].[Package] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_PackageID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_PackagingFicheID] FOREIGN KEY([PackagingFicheID])
REFERENCES [dbo].[Package] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_PackagingFicheID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_PayPlanID] FOREIGN KEY([PayPlanID])
REFERENCES [dbo].[PayPlan] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_PayPlanID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_ProjectID] FOREIGN KEY([ProjectID])
REFERENCES [dbo].[Project] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_ProjectID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_QualityControlForm] FOREIGN KEY([QualityControlForm])
REFERENCES [dbo].[FileData] ([Oid])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_QualityControlForm]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_ShippedTransactionLineID] FOREIGN KEY([ShippedTransactionLineID])
REFERENCES [dbo].[TransactionLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_ShippedTransactionLineID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_SourceWarehouseID] FOREIGN KEY([SourceWarehouseID])
REFERENCES [dbo].[Warehouse] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_SourceWarehouseID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_TransactionID] FOREIGN KEY([TransactionID])
REFERENCES [dbo].[Transaction] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_TransactionID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_TransferFicheLineID] FOREIGN KEY([TransferFicheLineID])
REFERENCES [dbo].[TransactionLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_TransferFicheLineID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_UnitID] FOREIGN KEY([UnitID])
REFERENCES [dbo].[ItemUnit] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_UnitID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_UnitSetID] FOREIGN KEY([UnitSetID])
REFERENCES [dbo].[UnitSet] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_UnitSetID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_UserDefinedSalesDispatchLineID] FOREIGN KEY([UserDefinedSalesDispatchLineID])
REFERENCES [dbo].[TransactionLine] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_UserDefinedSalesDispatchLineID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_VariantID] FOREIGN KEY([VariantID])
REFERENCES [dbo].[ItemVariant] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_VariantID]
GO

ALTER TABLE [dbo].[TransactionLine]  WITH NOCHECK ADD  CONSTRAINT [FK_TransactionLine_WorkOrderID] FOREIGN KEY([WorkOrderID])
REFERENCES [dbo].[WorkOrder] ([OID])
NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[TransactionLine] CHECK CONSTRAINT [FK_TransactionLine_WorkOrderID]
GO

*/