I have written a trigger that uses a Linked Server connection, but when it executes it gives me the following error message "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."
I do not know how to set the ANSI_NULLS and ANSI_WARNINGS, please help!
The following is the syntax of the trigger I have written:
INSERT LinkedSrvr.Scheduling.dbo.tblPartNumbers(fkPartNumberID,fkCustomerID,fkAlloyID,Description,Price,Units,ManufWeight)
SELECT S.InvtID,S.ProdMgrID,S.MaterialType,S.Descr,S.StkBasePrc,S.StkUnit,A.StdGrossWt
FROM Inserted S, InventoryADG A
WHERE S.InvtID = A.InvtID
AND S.S4Future10 = 1
Thanks,
RR
I do not know how to set the ANSI_NULLS and ANSI_WARNINGS, please help!
The following is the syntax of the trigger I have written:
INSERT LinkedSrvr.Scheduling.dbo.tblPartNumbers(fkPartNumberID,fkCustomerID,fkAlloyID,Description,Price,Units,ManufWeight)
SELECT S.InvtID,S.ProdMgrID,S.MaterialType,S.Descr,S.StkBasePrc,S.StkUnit,A.StdGrossWt
FROM Inserted S, InventoryADG A
WHERE S.InvtID = A.InvtID
AND S.S4Future10 = 1
Thanks,
RR